Topic: Optimization
-
This article describes how to optimize time intelligence calculations with DirectQuery over SQL in Power BI by avoiding time intelligence DAX functions. Read more
-
At SQLBI, Alberto Ferrari and I spend most of our time sharing our knowledge and expertise in DAX. We have been doing this for years, navigating through conferences, workshops, and videos, encountering many individuals – from eager beginners to seasoned… 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 explains a typical pattern to optimize a SUMX iterator by reducing the number of callbacks in the expression. Read more
-
Analyze the performance of different DAX techniques to identify any products without sales in an area or a time period. Watch now
-
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
-
GROUPBY and SUMMARIZE seem similar, but they differ in both performance and functionalities. Choose the right one depending on specific scenarios! Watch now
-
Both GROUPBY and SUMMARIZE are useful functions to group by columns. However, they differ in both performance and functionalities. Knowing the details lets developers choose the right function for their specific scenario. Read more
-
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
-
We recently released the second edition of the Optimizing DAX video course. Despite its volume, some details always did not find space in the training material. The REDUCED BY syntax of xmSQL is one of those details. Read more