Modify DAX filter context in Power BI Desktop models

Intermediate
App Maker
Data Analyst
Power BI
Microsoft Power Platform

By the end of this module, you'll be able to describe and work with filter context, which is used to evaluate measure formulas.

Learning objectives

By the end of this module, you'll be able to:

  • Describe filter context.
  • Use the CALCULATE function to modify filter context.
  • Pass filters to the CALCULATE function.
  • Pass filter modifiers to the CALCULATE function.
  • Perform context transition.

Prerequisites

You should have experience creating Microsoft Power BI Desktop models and designing Power BI report layouts. You should also understand how to define Data Analysis Expressions (DAX) measures and how to work with iterator functions.