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

 

Can I do something like CACULATE(SUM(COST), ALLSELECTED(Project.projectname), ALLSELECTED(Team.ProjectManagre)) ?

Need Help

4 Replies

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello. Have you ever been able to figure out a solution? I have a very similar question that no one seems to be able to answer!