SQLBits 2023
CALCULATE evaluation order
In this session I’ll show you a practical, visual and less verbose steps that are performed to evaluate the CALCULATE expression that has multiple filters/modifiers.
CALCULATE is the most important DAX function, yet its usage is still a challenge even for the most seasoned DAX developers.
In this session I’ll show you a practical, visual and less verbose steps that are performed to evaluate the CALCULATE expression that has multiple filters/modifiers.
To do so I’ll do a quick recap of CALCULATE filters/modifiers, evaluation order and precedence within nested CALCULATEs so we can deep dive into the multiple filters/modifiers within the same CALCULATE.
In this session I’ll show you a practical, visual and less verbose steps that are performed to evaluate the CALCULATE expression that has multiple filters/modifiers.
To do so I’ll do a quick recap of CALCULATE filters/modifiers, evaluation order and precedence within nested CALCULATEs so we can deep dive into the multiple filters/modifiers within the same CALCULATE.