Topic: SSAS
-
This article provides the best practice to use ADDCOLUMNS and SUMMARIZE, two functions that can be used in any DAX expression, including measures. Read more
-
The new DAX available in Excel 2016 and the data model in Power BI and Analysis Services 2016 offer tools to manage many-to-many relationships in a more efficient way than previous version, as described in this article. Read more
-
This article describes how to hide measures from a group of users by leveraging object-level security in Power BI and Analysis Services. Read more
-
This article is the state-of-the-art guide of the development tools for Power BI and Analysis Services models, providing guidance to improve productivity and access to new features. Read more
-
One of the first concepts to learn in DAX is the difference between calculated columns and measures. This article shortly recaps the differences and describes when to use each one. Read more
-
This article explains how to use SUMMARIZECOLUMNS, which is a replacement of SUMMARIZE and does not require the use of ADDCOLUMNS to obtain good performance. Read more
-
This article describes the types of relationships available in Power BI and Analysis Services, clarifying the differences in cardinality and filter propagation of physical relationships. Read more
-
This article describes how to control format strings in calculation groups. Before starting, we suggest you read the previous articles in this series. Read more
-
The Detail Rows Expression in a Tabular model provides the user with control over the drillthrough results obtained by showing details of a measure. This article describes typical DAX expressions you can use in this property. Read more
-
This article describes how to use the detail rows expression of a measure to obtain the equivalent of creating table functions in DAX. This allows the reusing of a table expression in multiple CALCULATE filters. Read more