ALLSELECTED with Multiple Slicer

[sabeensp]

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)) ?

[Anonymous]

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]

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!

[v-jiascu-msft]

Hi @sabeensp,

Could you please mark the proper answers as solutions?

Best Regards,

[Zubair_Muhammad]

@sabeensp

Looks fine to me.

Even you can use ALLSELECTED() i.e. without any arguments/parameters

More details about this function in the link below

https://dax.guide/allselected/