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?

MFelix's avatar
MFelix
Super User
6 years ago

Hi keyway ,

 

Looking at your expression I'm assuming that you have an attribute column with (Salary, Taxes and Comission) and some measures with Salary, Taxes and Comission correct?

 

If you just make the Salary + Taxes + Comissions using a slicer should give expected result since the calculation of each measure will only be made if you select the value.

 

If this is not expected result can you share a sample of you data and expected value please.

 

 

keyway's avatar
keyway
Frequent Visitor
6 years ago

Hi Miguel

 

Your assumptions are correct:

If i select more than one item using a slicer the result is always a blank value, if i select one single item from the slicer i get the correct value.

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    Hi keyway ,

     

    Try to add a +0 to the measure you have.