800 XP

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.
Start

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.

This module is part of these learning paths