The Fundamentals of DAX Contexts

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 -

Starts: 13:20 12th Mar 2022
Ends: 14:10 12th Mar 2022


Short Description
- 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.


James McGillivray


AzureOn PremisesIntelligence and AnalyticsVisualising and Actioning DataDevelopingModellingPower BIBeginnerWhat

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference


Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.