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
Icon for Super User rankSuper 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

 

You mean something like this Selection = "Taxes",[Taxes]+0 ?

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

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi keyway ,

     

    We use the dax similar to the following to capture the multiple values from slicer:

     

    Selecetvalues = values(table[slicer])

     

    Would you please inform us more detailed information( your sample data(by OneDrive for Business)) if possible? Then we will help you more correctly.

     

    Please don't contain any Confidential Information or Real data in your reply or files.

     

    Best Regards,

    Dedmon Dai