This article describes the behavior of auto-exist in DAX, explaining the side effects of combining slicers on columns of the same table in Power BI.  Read more

Estimating the cardinality of iterators is an important skill when optimizing DAX code. This article explains how to use this technique, evaluating different ways of computing the number of working days between two dates.  Read more

This article describes possible optimization approaches to improve the performance of nested iterators in DAX.  Read more

The Sort By Column feature in Power BI causes side effects that are important to know when writing a DAX formula. This article explains these side effects and how to write correct DAX code to avoid getting incorrect results.  Read more

This article describes how to use a measure to filter a Power BI visualization, and the different behaviors of a same filter between different visuals.  Read more

This article describes the differences between report-based tools and model-based tools. Because Power BI is a model-based tool and not a report-based tool, it is useful to have a quick reference guide explaining these differences.  Read more

This article describes how to use the detail rows expression of a measure to obtain the equivalent of creating table functions in DAX. This allows the reusing of a table expression in multiple CALCULATE filters.  Read more

This article describes how to optimize DAX expressions with mutually exclusive calculations that might cause slow query performance.  Read more

This article describes a very common optimization pattern that relies on variables to optimize conditional expressions in DAX.  Read more

In SQL there are different types of JOIN, available for different purposes. This article shows the equivalent syntaxes supported in DAX and it was updated in May 2018.  Read more