Forum Discussion
Multi Select Slicer
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.
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,
but this measure does not display any value. why it began like this.
how to achieve this goal.
Thanks in advance.
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])
1 Reply
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])