Topic: Optimization
-
Horizontal fusion is a new optimization technique available in DAX to reduce the number of storage engine queries. In this article, we introduce this optimization with some examples. Read more
-
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
-
This article describes how to use and interpret the information provided by the Power BI Performance Analyzer, finding the bottlenecks in slow reports. 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
-
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
-
DAX Studio 2.17 introduced improved server timings features to analyze the parallelism of storage engine operations. Watch now
-
This article describes the improved server timings features in DAX Studio 2.17 to analyze the parallelism of storage engine operations. Read more
