Forum Discussion

keyway's avatar
keyway
Frequent Visitor
6 years ago
Solved

Multi selection in a SWITCH(TRUE()

Hi   I have the followed measure   Selected Item =  VAR Selection = SELECTEDVALUE(Cost_Item,[Attribute],"All" RETURN SWITCH( TRUE(), Selection = "Salary", [Salary], Selection = "Taxes",...
Tutorial Requests
  • MFelix's avatar
    MFelix
    6 years ago

    Hi keyway ,

     

    Yes something similar to that.

     

    Can you share a small sample of data and how you are calculating the taxes, and other measures?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Try like

Selection IN {"Salary","Taxes"}, [Taxes]+[Salary]

keyway's avatar
keyway
Frequent Visitor
6 years ago

Hi

 

Yes, in fact that is the syntax i have on the code, i just missplaced the brakets on the message.

It shows a blank result

 

Thank you

 

  • SH-4's avatar
    SH-4
    Frequent Visitor
    2 years ago

    Was this ever actually resolved? I've tried Selection IN {a, b, c} = a + b + c and it does not work.

    I can only get my switch statement to work with single selection, but I need to be able to factor in for multiple selections and can't seem to find a solution if this is possible.

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      2 years ago

      Hi SH-4 ,

       

      Can you please share some more detials on your requeriments?