Modify DAX filter context in semantic models

Module
9 Units

Intermediate

Data Analyst

Power BI

Microsoft Fabric

Modifying the filter context in DAX lets you control how calculations evaluate data in Power BI semantic models. Gain deeper insights and tailor your analysis in your reports by choosing exactly what data is included in calculations.

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.

Introduction min
Understand filter context min
Modify filter context min
Use filter modifier functions min
Examine filter context min
Perform context transition min
Exercise - Modify DAX filter context min
Check your knowledge min
Summary min