DAX Explained Through Dance, Memes and Dad Jokes
Proposed session for SQLBits 2026TL; DR
Memorable explanations of CALCULATE filter and row context in DAX to take you're measures to the next level.
Session Details
Moving beyond the basics of DAX can as tough as learning to tap-dance without falling in the sink. Several key concepts such as row and filter contexts that you will need to understand must be grasped before more complex expressions can be confidently written.
This session will help anyone who is looking to move their formulae up to the next level (or looking to support others in doing the same) by providing novel approaches to understanding these important concepts.
Together we will explore filter contexts with punchlines, learn how row contexts are like a dance, and discover what CALCULATE has in common with Oprah Winfrey.
This session will help anyone who is looking to move their formulae up to the next level (or looking to support others in doing the same) by providing novel approaches to understanding these important concepts.
Together we will explore filter contexts with punchlines, learn how row contexts are like a dance, and discover what CALCULATE has in common with Oprah Winfrey.
3 things you'll get out of this session
While building DAX measures to understand:
Filter Context
Row Context
The impact of CALCULATE
Speakers
Barney Lawrence's other proposed sessions for 2026
(Almost) Everything You Wanted To Know About Purview Data Governance - 2026
An Introduction to Window Functions - 2026