Topic: DAX

       Page 5 of 149 articles
article –

Displaying Nth Element in DAX

This article describes how to create a measure displaying the name or value of an element that has a specific ranking, with different option for managing ties.  Read more

article –

Understanding DAX Auto-Exist

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

article –

Side effects of the Sort By Column setting in DAX

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

article –

Creating table functions in DAX using DETAILROWS

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