Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Ignore slicer filter in measure

I have a Measure which is a result of 2 other measures:

Shortage= [ReaminingQTYbyPU]+[Diff]
How to ignore a slicer filter in this measure? Thnaks!
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous Something like:

     

    Shortage= CALCULATE([ReaminingQTYbyPU]+[Diff],REMOVEFILTERS('SlicerTable'[Column]))

     

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Anonymous Something like:

     

    Shortage= CALCULATE([ReaminingQTYbyPU]+[Diff],REMOVEFILTERS('SlicerTable'[Column]))

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Greg_Deckler  sometimes things are easier than you think. Thanks a lot!