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
Barney Lawrence's previous sessions
Data Linkage Options: MDM vs Splink (PySpark)
Comparison of various data linkage solutions.
The Metadata Driven Data Warehouse
Tired of writing the same old Insert/Update/Delete statements over and over? Is your pipelines folder overflowing? Need to get your new data warehouse up and running as fast as possible?
Metadata (data about data) comes to the rescue and in this session we’ll show you how.
DAX as Dance-Contexts Explained
Dance your way to an understanding row and filter contexts in DAX.