Forum Discussion

Hennemann's avatar
Hennemann
Frequent Visitor
2 years ago
Solved

Negative filter als slicer

Hello everyone,   I have a small Issue regarding a slicer. I would like to have a slicer than can be used as negative filter. For example show me everything which does not include a specific tag. ...
negative filter
Slicer
  • Rupak_bi's avatar
    Rupak_bi
    2 years ago

    Create a Measure

    New tags = CALCULATE(Max(Tabelle1[Tags]),NOT(CONTAINSSTRING(Tabelle1[Tags],SELECTEDVALUE(Tags[Tags]))))
     
    • Use this measure in your matrix.
    • Remove the relationship between two table
Hennemann's avatar
Hennemann
Frequent Visitor
2 years ago

I am sorry for the confusion I may caused.
My target is a Slicer, which can be used as negative select
In this case the Highlighted Rows shouldn't be visible due to the slicer (basically show me every row which does not contain "paused")