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
Rupak_bi's avatar
Rupak_bi
Icon for Super User rankSuper User
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

Thank you that helped a lot.