Barney Lawrence
barneylawrence.com
Barney Lawrence has over a decade's experience on Microsoft data platforms working in social care, health and travel industries. He currently works as a Senior BI Developer for Jet2.com.
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.