Forum Discussion

Vallirajap's avatar
Vallirajap
Resolver III
2 years ago
Solved

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 th...
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    2 years ago

    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])

amitchandak's avatar
amitchandak
Super User
2 years ago

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])