Business Intelligence

DPW02 Understanding DAX, It's All About the Context

11/20/2024

8:00am - 9:15am

Level: Introductory to Intermediate

Angela Henry

Data Platform MVP

Principal Consultant

Fortified

How many times have you created a Power BI report and gotten an unexpected or inconsistent result, then spent an absurd amount of time trying to figure where the result came from? This happens with almost everyone when they start writing DAX. The key to understanding DAX is context, evaluation context. This session won't provide the magic bullet to becoming a master at DAX, but will help you understand evaluation context, so the next time you create a measure, the result will be not only consistent, but expected.

You will learn:

  • Understand filter context
  • Understand row level context
  • Understand how the combination of filter context and row level context equal evaluation context