22-25 April 2026 
Understanding CALCULATE, the queen of all DAX functions
Proposed session for SQLBits 2026TL; DR
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
Session Details
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.
3 things you'll get out of this session
- Understanding the purpose of CALCULATE
- See simple examples of using CALCULATE in practice
- Understand how to use CALCULATE to write the right DAX code for your business purposes
