Forum Discussion

Zx2000's avatar
Zx2000
Advocate I
3 years ago

Help me understand Calculate steps

Hello, I am trying to learn DAX and many things there are a real mystery which leads to rael frustration. At this stage Ii am trying to understand steps for CALCULATE from a DAX Bible, however there...
CALCULATE
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Zx2000 
The filter argument ( FILTER ( ALL (  'Product'[Color] ),  'Product'[Color] = "Red" ) is first evaluated.

Then the CALCULATE modifiers KEEPFILTERS and ALL are applied over the outer filter context therefore, the outer filter will be kept all. In other words each color in the outer filter context will become all the colors and it will not be replaced by the inner filter rather it will be intersected with it. Apparently, the intersection between all the colors and "Red" will result in "Red" everywhere. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, 

Alberto in their Mastering DAX course said that KEEPFILTERS is not CALCULATE modifier therefore if there is second argument using ALL then ALL is used first because it is a modifier. Then in one of their page I read that KEEPFILTERS is CALCULATE modifier.

 

So which is it?????????