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...
hnguy71
Super User
Super UserHi dataforhumans
The following removes the filter context from your measure: You can try this:
CALCULATE([sum_measure], ALL(is_filterable))