22-25 April 2026 
Video unavailable
SQLBits 2026
Understanding CALCULATE, the queen of all DAX functions
This session will show how to use CALCULATE and the basics on how it works, furthermore showing a full example of writing a complex DAX measure using CALCULATE starting from the definitions and getting to the final DAX code
CALCULATE is the most powerful DAX function as it allows to manipulate the filter context at your will, like in the case of time-intelligence calculations. Yet, the function is not easy to understand unless its full algorithm is completely clear. In this session the algorithm will be disclosed together with a set of examples of increasing complexity with the aim to reach a complete, yet guided and gradual, understanding of the CALCULATE function. At the end of the session a full picture of CALCULATE will be in the participants' hands.
