Understanding CALCULATE, the queen of all DAX functions

Proposed session for SQLBits 2026

TL; 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