Forum Discussion

msantillan's avatar
msantillan
Icon for Helper II rankHelper II
6 years ago
Solved

DAX - Selecting 2 or more specific slicer values

Is there a way to show data based on two sepcific values selected on a slicer?   I have this DAX code:   Productive Utilization = SWITCH(true(), SELECTEDVALUE('Resource Slicer Values'[Slicer Opt...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago
     
    Try this 
     
     
    Check =
    var first_val="FQC"
    Var Second_val="RHC"
    VAr SelectedList=ALLSELECTED('Parameter Location Type'[Location Type])
    return
    SWITCH(TRUE(),first_val in SelectedList || Second_val in SelectedList,1,0)
     
    Note: chnage values and column name as per your requirement.
     
     
    I tried above one and working absolutely fine .
     
    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.
Anonymous's avatar
Anonymous
Not applicable
6 years ago
 
Try this 
 
 
Check =
var first_val="FQC"
Var Second_val="RHC"
VAr SelectedList=ALLSELECTED('Parameter Location Type'[Location Type])
return
SWITCH(TRUE(),first_val in SelectedList || Second_val in SelectedList,1,0)
 
Note: chnage values and column name as per your requirement.
 
 
I tried above one and working absolutely fine .
 
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.
msantillan's avatar
msantillan
Icon for Helper II rankHelper II
6 years ago

Thanks!