Forum Discussion
Preventing certain rows from being filtered in calculated measure
I have a measure to be calculated that should respond to slicers on the page, but it should never filter out a certain subset of rows denoted by a boolean column. So for the table: Value Col...
Hi all,thanks for the quick reply, I'll add more.
Hi dataforhumans ,
Regarding your question, you want the line items to be affected by the slicer, but the sum not to be affected by the slicer, correct?
The Table data is shown below:
You can use the 'Calculate' function to override the outer filter condition with the inner filter condition.
Measure = CALCULATE(SUM('Table'[Value]),'Table'[is_filterable] = TRUE() || 'Table'[is_filterable] = FALSE())Final output
If I understand you wrongly, please provide more information.
Best Regards,
Wenbin Zhou