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...
Tag: FILTER
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 4
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...
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 3
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,...
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 2
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,...
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 1
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,...