Forum Discussion

Community Champion

7 years ago

Solved

DAX: Puzzling ALL behaviour in context transition

Hi there, I have the following calculated columns in the 'Product' table of the Contoso data model (available here). 'Product'[ProductKey] has 2517 unique values. A) ‘Product’[Test 1]=CALCULA...

Need Help

Phil_Seamark
7 years ago
Hi AlB and MattAllington

I did email Jeffrey Wang about this issue recently and he confirmed it is a bug and that it will be fixed in a future release. I don't have a timeframe, unfortunately.

v-danhe-msft

Microsoft Employee

7 years ago

Hi AlB,

Based on my research, it is due to the simple useage of calculate funtion and the dax engine-The VertiPaq Engine in DAX, when you are using one parameter in calculate function, it takes the existing row contexts (if any) and transforms them into an equivalent filter context.

You could refer to below link:

https://powerpivotpro.com/2014/03/becoming-one-with-calculate/

https://www.microsoftpressstore.com/articles/article.aspx?p=2449192&seqNum=2

And you could refer to the Chapter 5 Understanding CALCULATE and CALCULATETABLE in the book

"The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI"

Regards,

Daniel He