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

This article explains the precedence of calculation groups in DAX, needed whenever multiple calculation groups are present within the same model. Before starting, we suggest you read the previous articles in this series.  Read more

Data lineage is such a well-implemented DAX feature that most developers use it without knowing about it. This article describes data lineage and how it can help in producing better DAX code.  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

This article describes what limited relationships are and the differences between regular and limited relationship in Power BI and DAX.  Read more

This article describes how to display the filter context applied to a calculation using a special DAX measure in Power BI Tooltips.  Read more

This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to improve performance in these cases.  Read more

This article shows how to compute a measure that sums the values produced row by row in the visual into the visual total, instead of recomputing the total value in the filter context of the total.  Read more

This article shows how to add an additional “other” row to the selection obtained using the Top N filter in a Power BI report.  Read more

This article describes how to compute previous year values up to a certain date. This is useful in case the data is presenting incomplete months or years.  Read more