ALLSELECTED is a powerful, yet dangerous function. This article describes the best practices to follow to avoid falling into the pitfalls involved with ALLSELECTED. ALLSELECTED CALCULATE modifier Returns all the rows in a table, or all the values in a… Read more
When should you use DISTINCT over VALUES in DAX? Here is how to write resilient measures that survive bad data and model changes. DISTINCT Returns a one column table that contains the distinct (unique) values in a column, for a… 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. IF Checks whether a condition is met, and returns one value if TRUE, and another value… Read more
This article describes how to control the execution of DAX code when there are either multiple or empty selections of calculation items in calculation groups. Read more