Forum Discussion

Zx2000's avatar
Zx2000
Icon for Advocate I rankAdvocate 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
Icon for Community Champion rankCommunity Champion
3 years ago

OwenAuger, CNENFRNL, Greg_Deckler 
Are the top active members in the community who have the ultimate understanding of the evaluation contexts. Hopping any of them having the time explain this behaviour of CALCULATE.

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
3 years ago

tamerj1 thank you for the compliment, I'm really flattered!

 

Zx2000 

Above all, unlike Excel formula, DAX measures are super, super, super ... sensitive to all elements in its evaluation context; literally means, any element  (relationship, row/column, slicer ...) does impact on the calculation.

As for your measure, I can't comment more than just simply it this way now, given that there is no data model available.

test 1 =
CALCULATE(
    [Sales Amount],
    KEEPFILTERS( 'Product'[Color] = "Red" ),
    ALL( 'Product'[Color] )
)