SQLBits 2022

The Fundamentals of DAX Contexts

Understanding how DAX determines evaluation context is a critical skill for a Power BI Developer. Writing anything other than the most simple measures requires this skill. In this session we'll explore Filter Context and Row Context individually, and how they combine to form Evaluation Context. We'll have a look at a number of simple measures and visualise how the context affects them.
DAX is an extremely versatile and powerful language, but once we move beyond simple measures it is imperative to understand the idea of CONTEXT to take our skills to the next level. In this session we will understand the different contexts in DAX and how each one is resolved. We will use practical demonstrations to see how various DAX functions affect context and how to ensure that our DAX is doing what we mean it to.

Feedback Link - https://sqlb.it/?7208