Modify DAX filter context in Power BI Desktop models

Intermediate
App Maker
Data Analyst
Power BI
Microsoft Power Platform

Filter context describes the filters that are applied during the evaluation of a measure or measure expression.

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.