Forum Discussion
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...
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))
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))