- Row context in Power BI refers to operations that process one row at a time, like calculated columns that automatically iterate through each row to apply calculations.
- Measures do not have row context by default; to perform row-wise calculations in measures, iterative functions like SUMX are used to scan the table row by row.
- Filter context exists by default in Power BI and influences calculations based on slicers, filters, visuals, and relationships between tables.
- Adding columns or slicers changes the filter context to restrict data shown, and DAX functions like CALCULATE can be used to create custom filter contexts.
- Relationships between tables propagate filter context, usually in a one-to-many flow, which affects how data is filtered and summarized.
- The ALL function can be used in a measure to ignore any filter context applied, providing grand totals or unfiltered results.
Comments
Post a Comment