Understanding DAX Through Pictures - Part 2

Proposed session for SQLBits 2026

TL; DR

See DAX like never before. Learn how evaluation context works through clear visuals and practical examples. Perfect for anyone who wants to understand DAX without the confusion.

Session Details

DAX can feel like a black box where things either work or fail without explanation. In this extended session, we’ll break that mystery wide open using visuals that make sense. You’ll see how evaluation context really works and why it matters for every calculation. We’ll explore row context, filter context, and measure design in a way that clicks for visual learners. If you’ve struggled to understand why DAX behaves the way it does, this session will give you clarity and confidence to build better models and measures.

3 things you'll get out of this session

A clear understanding of evaluation context and how it drives DAX calculations. Visual models that make row context, filter context, and measure design easy to grasp. Practical techniques to build accurate, efficient measures with confidence.

James McGillivray's other proposed sessions for 2026

5 Design Patterns for Better Looking Reports - 2026

From Ranking to Rolling Totals: Windowing Functions Explained - 2026

Seconds to Save Lives: Real World Real-Time Intelligence with Fabric - 2026

Solving Real Business Challenges with DAX - 2026

Super Simple Fabric Workloads Make You Feel Precocious - 2026

The Force Awakens: Charting Your Career Path with the Data Community - 2026

Turning Data Into Stories People Remember - 2026

Understanding DAX Through Pictures - Part 1 - 2026

YMCA: You Must Consider Accessibility - 2026

Same Words, Different Worlds: Communication Across Domains, Roles and Ranks - 2026

James McGillivray's previous sessions

The Fundamentals of DAX Contexts

Explore the heart of DAX with this unique session, as I take you on an African Safari-themed adventure, where stunning wildlife photography serves as the backdrop for understanding the intricacies of DAX contexts. We'll encounter row and filter contexts, just like wild creatures in their natural habitat. Through captivating visuals, you'll uncover how these contexts shape DAX calculations and measure outcomes. Whether you're a data analyst or a business intelligence enthusiast, this session ensures a memorable and educational experience. Understanding DAX Contexts is your gateway to mastering DAX while enjoying the captivating beauty of African wildlife. Don't miss this opportunity to embark on your DAX adventure.

Fabric Power Hour

The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!