Forum Discussion

anwarbi's avatar
anwarbi
Icon for Helper III rankHelper III
4 years ago

Preventing Measure to interact with Slicer

Hi,    In the below measure, I want a slicer to interact with the first half of the measure (the bold part), but do not want the slicer to interact with the second half of the measure.  Difference...
Need Help
TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi anwarbi 

 

You can do a few things to achieve this:

 

  1. Use "Edit Interactions" to stop the filters interacting with the specific visual. 
  2. You can create a second measure on top of your existing measure.

If you want to use the second approach, just add a new measure like this:

 

Measure 2 = CALCULATE ( [Difference in Sales] , ALL ( 'Table' ) )

 

Hope this helps!

Theo 🙂