-
Activating bidirectional cross-filter in a Tabular data model might create ambiguous paths in the chain of relationships, resulting in very dangerous models as numbers become unpredictable. This article provides a deep explanation of the kind of ambiguity that might appear… Read more
-
This article is the state-of-the-art guide of the development tools for Power BI and Analysis Services models, providing guidance to improve productivity and access to new features. Read more
-
If there is a conference you should attend at least once, it is SqlBits. Why? Because it is magic. It is impossible to imagine organizing such an international event with a team of volunteers. It is against common sense actually… Read more
-
You can rely on DAX expressions to control the behavior of some aspects of Power BI visuals. This article shows a few examples of managing the range of charts. Read more
-
This article describes how to analyze the performance of a DAX measure based on a DISTINCTCOUNT calculation and how to evaluate possible optimizations. Read more
-
This article describes how to read the active security roles in a Tabular model for Power BI or Analysis Services. This way, you can use measures and calculation groups to customize a report based dynamically on security roles active for… Read more
-
This article describes a reference Date table in DAX using a Power BI template. The same technique can be used in Analysis Services models. Download the latest version of the template in the Dax Date Template page. Read more
-
The blank value in DAX is a special value requiring particular attention in comparisons. It is not like the special null value in SQL, and it could appear in any conversion from a table expression. This article explores in details… Read more
-
This month we published a second draft of the Window functions in DAX whitepaper for the SQLBI+ subscribers. After the first draft we published in January 2023, we added new sections and updated others. We completely rewrote the “apply semantics”… Read more
-
Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. Read more