Forum Discussion

AlB's avatar
AlB
Icon for Community Champion rankCommunity 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's avatar
    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's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi AlB,

The sample file you have offered could not be opened due to the license problems coudl you please just share some sample file to have a test?

And the formula you have offered in ‘Product’[Test 1]=CALCULATE(ALL(’Product’[ProductKey])) seemed wrong, if you want to use the CALCULATE function, you should have an Aggregate function in it, could you please modify your formula and test it again?

 

Regards,

Daniel He

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi v-danhe-msft

Here's another file.

There is no error. Both 'Test 1' and 'Test 2' work as you can see in the attached file. I am just trying to understand why the interaction between context transition and ALL() seems to be different in 'Test 1' than in 'Test 2'

Thanks