Forum Discussion

sabeensp's avatar
sabeensp
Icon for Helper IV rankHelper IV
7 years ago

ALLSELECTED with Multiple Slicer

Is there a way to to write ALLSELECTED DAX with multiple slicer values   Example: Slicer 1 has Project Name (Project.projectname) Slicer 2 has Project Manager (Team.ProjectManagre) and so on   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi sabeensp 

Not sure if you've got the solution for this. I know it's very late for the reply but I was in a similiar situation and what worked for me was using CALCULATE function, with two ALLSELECTED arguments, both from different tables. That did the trick for me: 

 

Total_JS_Ex_Industry = CALCULATE([NumberESSJobSeekers],
ALLSELECTED(ANSZIC[Industry]),
ALLSELECTED(Connect_Applicants[ApplicationStatus]))

 

Hopefully this helps