Forum Discussion

JileMeyn's avatar
JileMeyn
New Member
4 years ago
Solved

DAX function with Slicers

I have three slicers: Department Location Senior Manager I currently have it set up to have my tables appear blank until Location is selected by using this funtion:   Blank = IF(ISFILTERED(M...
Need Help
  • JileMeyn's avatar
    JileMeyn
    4 years ago

    I figured it out, for anyone else that needs help with the issue this was the expression that worked.

     

    Senior Blank = SWITCH(SELECTEDVALUE(Master[Location]),"YYC", IF(ISFILTERED(Master[SR Manager]),1,0),"YUL",IF(ISFILTERED(Master[SR Manager]),1,0),"YMX", IF(ISFILTERED(Master[SR Manager]),1,0),"YYZR", IF(ISFILTERED(Master[SR Manager]),1,0), if(ISFILTERED(Master[Location]),1,0))
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi JileMeyn 

 

Please try using this in place of your selectedvalue :

CONCATENATEX (
    VALUES ( Master[Location] ),
    ", "
)

What this does is, it picks all the values selected in the Location slicer and concatenates them.

 

If you think this helped, please give a kudos and Mark it as a solution if it worked. 
Let me know if you need help 🙂

 

Cheers,

Mahesh

 

  • JileMeyn's avatar
    JileMeyn
    New Member
    4 years ago

    How does that work to only select those 4 locations? It gives me an error when I try and add more then one.

     

    Senior Blank = SWITCH(CONCATENATEX(VALUES(Master[Location]), "YYC","YUL", IF(ISFILTERED(Master[SR Manager]),1,0), if(ISFILTERED(Master[Location]),1,0)))