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 in Sales = Sheet1[% of overall sales]-(sheet1[% of Partners sales])
 
Can anyone please help me to fix this.
 
Thanks
 
Need Help

2 Replies

  • 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 🙂

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi anwarbi 

    I do not quite understand what you mean. Can you show your needs in the form of graphs and data ?

     

    Best Regard

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.