cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Marcuskw Frequent Visitor
Frequent Visitor

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

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

2 REPLIES 2
Hasan Regular Visitor
Regular Visitor

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

Capture.JPG

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

Hardik Established Member
Established Member

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