Forum Discussion

JileMeyn's avatar
JileMeyn
New Member
4 years ago
Solved

DAX function with Slicers

I have three slicers:

  1. Department
  2. Location
  3. 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(Master[Location]), 1,0)
 
Then having a filter on the Visual for 1.
 
But there are 4 locations where I need the user to select a senior manager before it will display the information. I got it to work for one location using a SWITCH expression but how do I add on the 3 additional locations to a SELECTEDVALUE?
 
Senior Blank = SWITCH(SELECTEDVALUE(Master[Location]), "YYC", IF(ISFILTERED(Master[SR Manager]),1,0), if(ISFILTERED(Master[Location]),1,0))
 
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))

3 Replies

  • 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)))
  • JileMeyn's avatar
    JileMeyn
    New Member
    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))