article

Using EXPAND and COLLAPSE in visual calculations

This article provides examples of visual calculations where the use of EXPAND and COLLAPSE is required to obtain the correct result.  Read more

article

KEEPFILTERS: a new DAX feature to correctly compute over arbitrary shaped sets

Having read this question on the mdsn blogs, I investigated on the KEEPFILTERS function and, after having learned it, it is now time to write about it. Moreover, before start to write about it, I need to thank the dev team…  Read more

Having read this question on the mdsn blogs, I investigated on the KEEPFILTERS function and, after having learned it, it is now time to write about it. Moreover, before start to write about it, I need to thank the dev…  Read more

article

Understanding circular dependencies in DAX

This article explains how to avoid circular dependency errors that can occur in DAX when two or more entities (calculated columns or calculated tables) reference one another in such a way that the engine cannot compute their value.  Read more

article

Using ALLEXCEPT versus ALL and VALUES

ALLEXCEPT is a handy DAX function to retrieve all the columns of a table except for some. When used as a CALCULATE modifier, its behavior is less intuitive and might result in inaccurate measures. In this article, we elaborate on…  Read more

article

Optimizing LASTNONBLANK and LASTNONBLANKVALUE calculations

This article explains the behavior of LASTNONBLANK, LASTNONBLANKVALUE, and similar DAX functions, also providing patterns for performance optimization.  Read more

article

Relationships in Power BI and Tabular models

This article describes the types of relationships available in Power BI and Analysis Services, clarifying the differences in cardinality and filter propagation of physical relationships.  Read more

article

Using the SELECTEDVALUE function in DAX

This article describes how the SELECTEDVALUE DAX function simplifies the syntax required in many scenarios where you need to read a single value selected in the filter context.  Read more

Does PowerPivot handle Parent/Child hierarchies? The common answer is “no”, since it does not handle them natively. During last PowerPivot course in London, I have been asked the same question once more and had an interesting discussion about this severe…  Read more

article

Expanded tables in DAX

Expanded tables are the core of DAX; understanding how they work is of paramount importance. This article provides a theoretical foundation of what expanded tables are, along with fundamental concepts useful when reading DAX code.  Read more