Create a measure that doesn't change with filter/slicers

[Marcuskw]

Hi,

I'm interested in creating a measure that doesn't change with Filter/Slicer settings to be included as a benchmark.

I've tried writing:

Revenue = CALCULATE(SUM(Table[Amount]);Table[Category]="Revenue";ALL(Table[City]))

However this still effects the measure when clicking on the filter

Br

Marcus

[Hardik]

https://community.powerbi.com/t5/Desktop/Ignore-Slicer-in-measure/m-p/212422#M93801

This is the solution you may be looking for

[Hasan]

You can use the Edit Ineractions option under the format option and select non