Tag: FILTER

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Analysis Services problems (Part 2)

by

Troubleshooting SQL Server 2017 Analysis Services problems (Part 2) If you have problems with SQL Server 2017 Analysis Services (SSAS 2017), review this troubleshooting checklist to find potential solutions. 1. If you cannot connect to SQL Server 2017 Analysis Services, ensure that SQL Server Browser service is started and was running under the account that has local administrator rights. The...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 4

by

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 4 After gaining an overview and performing the preparation for the four-parts of this article in Part 1, we introduced the COUNTROWS() function in Part 2. Then, in Part 3, we explored another DAX function, FILTER(). As we shall see in this, Part 4, of our...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 3

by

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 3 In the charter article of this series, DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, we introduced the powerful PowerPivot / DAX combination, noting that this add-on to Microsoft Office Excel 2010 (embedded, and only needing to be enabled,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 2

by

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 2 In the charter article of this series, DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, we introduced the powerful PowerPivot / DAX combination, noting that this add-on to Microsoft Office Excel 2010 (embedded, and only needing to be enabled,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 1

by

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 1 In the charter article of this series, DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, we introduced the powerful PowerPivot / DAX combination, noting that this add-on to Microsoft Office Excel 2010 (embedded, and only needing to be enabled,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →