Topic: DAX
-
When should you use DISTINCT over VALUES in DAX? Here is how to write resilient measures that survive bad data and model changes. Read more
-
When using time intelligence functions, the automatic REMOVEFILTERS on Date can make maintaining filters on the Date table challenging. This article shows a technique to handle filter-preserving columns in DAX. 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. 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
-
How to implement security in Tabular semantic models considering different requirements, data model design, DAX implementation, and performance. Read more
-
Learn how to write DAX queries and how to manipulate tables in DAX measures and calculated columns. Read more
-
Implement a dynamic Pareto calculation in Power BI based on a measure that can be selected from a slicer and dynamically filtered by other slicers in the report. Watch now
-
This article describes how to implement a dynamic Pareto calculation in Power BI based on a measure that can be selected from a slicer and dynamically filtered by other slicers in the report. Read more
-
I usually do not write about announcements and new features until we have had time to try and test them in the real world. However, there are always exceptions, and some of the announcements at the Microsoft Fabric Conference 2025… Read more
