Topic: SSAS
-
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
-
Tabular models (including Power BI) require marking the Date table as a date table to get appropriate results with time intelligence calculations. This article explains why this setting is required. Read more
-
ALLEXCEPT is a handy DAX function to retrieve all the columns of a table except for some. When used as a CALCULATE modifier, its behavior is less intuitive and might result in inaccurate measures. In this article, we elaborate on… Read more
-
The new video course to create enterprise-level solutions with Power BI and Analysis Services is available! Read more
-
Discover the pros and cons of disabling attribute hierarchies in Power BI and Analysis Services by modifying the “Available in MDX” property. We will analyze the difference in memory and performance that you can obtain by modifying a Power BI… Watch now
-
Large models in Power BI Premium have now a larger segment size like Analysis Services. Is this important? Does it improve compression or performance? When? This unplugged video shows the early tests and benchmarks, in preparation for a future and… Watch now
