Global edit history

How do filter context and row context work in DAX, and when should you use CALCULATE()?

PowerBI & DAX Measures · 2 saved versions

Back to thread

Version 1 (Edit)

Edited by Ishaan Patel · Aug 24, 2026 4:42 AM

0 edit points 0 upvotes
Change note

Content depth regeneration via community:regenerate-content

Title snapshot

How do filter context and row context work in DAX, and when should you use CALCULATE()?

Summary snapshot
Understanding context transition, CALCULATE filter overrides, and performance optimization.
Content snapshot
### DAX Core Concepts 1. **Row Context**: Evaluates calculations row-by-row during calculated column creation or iterator functions (`SUMX`). 2. **Filter Context**: The active subset of data filtered by user slicers and report visuals. 3. **CALCULATE()**: The primary DAX function that transforms Row Context into Filter Context and modifies existing filter contexts.
Source snapshot

https://learn.microsoft.com/en-us/dax/dax-overview

Version 1 (Original Post)

Published by Ishaan Patel · Aug 9, 2026 5:37 AM

Original Publication
Events Log

Post originally created and published to the Global Hub.

Original Title

How do filter context and row context work in DAX, and when should you use CALCULATE()?

Original Summary
Understanding context transition, CALCULATE filter overrides, and performance optimization.
Original Content
### DAX Core Concepts 1. **Row Context**: Evaluates calculations row-by-row during calculated column creation or iterator functions (`SUMX`). 2. **Filter Context**: The active subset of data filtered by user slicers and report visuals. 3. **CALCULATE()**: The primary DAX function that transforms Row Context into Filter Context and modifies existing filter contexts.
Original Sources

https://learn.microsoft.com/en-us/dax/dax-overview