Forum Discussion

biancak's avatar
biancak
Frequent Visitor
2 years ago
Solved

SWITCH isn't working properly

I am trying to create a filter for a few slicers. The desired result is only showing a branche in the branche slicer when there is a case with data so I'm not filtering branches and getting no results in my visuals.

We are working with parameters, so a selected value is needed to see which parameter is selected. The following calculation is used: 

SWITCH(
    AND(SELECTEDVALUE(Meetwaarden[Meetwaarde], "Zaken bestuursrecht"), [Aantal zaken bestuursrecht] > 0), 1,
    AND(SELECTEDVALUE(Meetwaarden[Meetwaarde], "Zittingen bestuursrecht"), [Aantal zaken bestuursrecht] > 0), 1,
    AND(SELECTEDVALUE(Meetwaarden[Meetwaarde], "LOD-inningen"), [Aantal zaken bestuursrecht] > 0), 1,
    AND(SELECTEDVALUE(Meetwaarden[Meetwaarde], "Invorderingen"), [Aantal zaken bestuursrecht] > 0), 1,
    AND(SELECTEDVALUE(Meetwaarden[Meetwaarde], "Aanmaningen"), [Aantal zaken bestuursrecht] > 0), 1, 0)

The Meetwaarden[Meetwaarde] is TEXT and the measures are WHOLE NUMBER. Which is why I don't understand the following error.

 

 

Does someone know how to fix this?

Need Help
  • mlsx4's avatar
    mlsx4
    2 years ago

    Hi biancak 

     

    I think you should add TRUE():

     

    SWITCH(TRUE(),
    SELECTEDVALUE(Meetwaarden[Meetwaarde])="Zaken bestuursrecht" && [Aantal zaken bestuursrecht] > 0, 1,
    SELECTEDVALUE(Meetwaarden[Meetwaarde])="Zittingen bestuursrecht" &&[Aantal zaken bestuursrecht] > 0, 1,
    SELECTEDVALUE(Meetwaarden[Meetwaarde])= "LOD-inningen" &&[Aantal zaken bestuursrecht] > 0, 1,
    SELECTEDVALUE(Meetwaarden[Meetwaarde])="Invorderingen" && [Aantal zaken bestuursrecht] > 0, 1,
    SELECTEDVALUE(Meetwaarden[Meetwaarde])="Aanmaningen" &&[Aantal zaken bestuursrecht] > 0, 1,
 0)

     

     

     

    I will also replace AND function with && operator

3 Replies