Topic: Optimization
-
This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT or FILTER. Read more
-
The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. Watch now
-
The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. Read more
-
This article describes how to return BLANK instead of zero in a DAX measure. Using this technique, you can remove rows in a Power BI matrix visual where the result of a measure is zero. Read more
-
Learn why you should use ADDCOLUMNS in DAX to compute aggregations instead of doing that inside SUMMARIZE: performance can be very different! Watch now
-
In composite models, any query can be executed on the remote model (wholesale execution) or by mixing local and remote engines together (retail execution). This video describes the differences between the wholesale and retail modes in composite models. Watch now
-
Analyze and measure the performance of an alternative data modeling solution suggested by Daniel Otykier (author of Tabular Editor) regarding the article Different options to model many-to-many relationships in Power BI and Tabular. Which solution is faster? Or “it depends”?… Watch now
-
A filter argument in CALCULATE is always an iterator. Finding the right granularity for it is important to control the result and the performance. This article describes the options available to create complex filters in DAX. Read more
-
This article describes the improved server timings features in DAX Studio 2.17 to analyze the parallelism of storage engine operations. Read more
-
DAX Studio 2.17 introduced improved server timings features to analyze the parallelism of storage engine operations. Watch now