22-25 April 2026 
SQLBits 2020
DAX as Dance-Contexts Explained
Dance your way to an understanding row and filter contexts in DAX.
Dance your way to an understanding row and filter contexts in DAX.
This 20 minute session swaps out the query engine for the dance hall to illustrate how DAX functions in calculations that involve both row and filter contexts alongside context transitions driven by the CALCULATE function.
By the end of the session you should have a better understanding of all three concepts and be ready to make your measures dance.
Speakers
Barney Lawrence's other proposed sessions for 2026
(Almost) Everything You Wanted To Know About Purview Data Governance - 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.