Multi Select Slicer

[Vallirajap]

Hi Team,

I stuck to one scenario. which is when I select more than one in a slicer, it is not working. Below, I list out the details.

I have one disconnected table, like below.

using this table to control a measure using dax

1. Based on grade I have 1 measure [MaxSalaryByGrade].
2. Based on the function, I have 1 measure [MaxSalaryByFunc].
3. Based on the OU I have 1 measure [MaxSalaryByOU].

Now I create another measure to interact with the measure using the above table, like Below.

Max = SWITCH( TRUE(),

             SELECTEDVALUE('Currency'[Index]) =4, [MaxSalaryByGrade],

             SELECTEDVALUE('Currency'[Index]) =5, [MaxSalaryByFunc],

             SELECTEDVALUE('Currency'[Index]) =6, [MaxSalaryByOU])

Now the measure will interact perfectly with the above table. When I try to add on another one, like when I click "Grade and OU" in a slicer, at the same time, the Max measure displays another measure [MaxSal_G&O].
So that I can rewrite the query below,

Max =  SWITCH( TRUE(),

                 SELECTEDVALUE('Currency'[Index]) = 4 && SELECTEDVALUE('Currency'[Index]) = 6, [MaxSal_G&O],

                 SELECTEDVALUE('Currency'[Index]) =4, [MaxSalaryByGrade],

                 SELECTEDVALUE('Currency'[Index]) =5, [MaxSalaryByFunc],

                 SELECTEDVALUE('Currency'[Index]) =6, [MaxSalaryByOU])

but this measure does not display any value. why it began like this. 
how to achieve this goal.

Thanks in advance.

[amitchandak · Accepted solution]

@Vallirajap , try like

Max = SWITCH( TRUE(),
countrows(interset(values('Currency'[Index]), {4,6})) =2, [MaxSal_G&O],
SELECTEDVALUE('Currency'[Index]) =4, [MaxSalaryByGrade],
SELECTEDVALUE('Currency'[Index]) =5, [MaxSalaryByFunc],
SELECTEDVALUE('Currency'[Index]) =6, [MaxSalaryByOU])