Topic: Optimization
-
Visual calculations can either improve or degrade the performance of a report. In this article, we outline how we ensure visual calculations have a positive impact on performance. Read more
-
Applying security roles to a Power BI model or to an SSAS Tabular database might impact query performance. This article describes existing issues and possible workarounds. This is an advanced article; a good knowledge of the storage engine and formula… Read more
-
This article analyzes the performance of regular versus limited relationships in DAX to understand the implications of using limited relationships. Read more
-
In this article, we examine the details of executing DAX code, with a focus on how the IF function is implemented in various scenarios. Read more
-
This article describes how to optimize inventory calculations in DAX by using snapshots to avoid the computational cost of a complete running total. Read more
-
We are proud to announce the availability of our new book, Optimizing DAX. Read more
-
This article describes how to optimize time intelligence calculations with DirectQuery over SQL in Power BI by avoiding time intelligence DAX functions. Read more
-
This article explains a typical pattern to optimize a SUMX iterator by reducing the number of callbacks in the expression. Read more
-
Writing measures referencing other measures is in general a good idea that simplifies the DAX code, but you might face specific bottlenecks. This article describes which performance issues might arise when different measures aggregate the same column using different filter… Read more
-
This article describes how to analyze the performance of a DAX measure based on a DISTINCTCOUNT calculation and how to evaluate possible optimizations. Read more