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
This article explains why you might encounter a curious error when placing columns from unrelated tables in a Power BI matrix. Read more