Forum Discussion
DAX - Can a Calculated Column Ignore Row Context and Keep Table Filter Context?
Is it possible for a DAX Calculated Column to keep table filter context but ignore row filter context? I have tried every combination of CALCULATE, EARLIER, and ALL, ALLEXCEPT, ALLSELECTED to no avai...
Hi, try with:
Household Count M =
CALCULATE (
SUM ( Table1[Household Count] ),
FILTER ( ALL ( Table1 ), Table1[Symbol] = EARLIER ( Table1[Symbol] ) )
)Regards
Victor
When using ALL, it ignores both ROW CONTEXT and TABLE FILTER CONTEXT, so this will not achieve what I am trying to do. It computes the SUM for all rows in the table, not the current rows based on the TABLE FILTER CONTEXT.
This is not what you expected?
Is you want to this column will be dynamic, that's not possible. The calculated columns are "calculated" when the model is loading. Not change with filters or slicers in the report visual.
Regards
Victor
Filter Key to keep only the top 2 rows. Does the result change?