Is there a way to to write ALLSELECTED DAX with multiple slicer values where slicers come from different Dim Tables?
Slicer 1 has Project Name (DimProject[ProjectName])
Slicer 2 has Project Manager (DimTeam[ProjectManager])
Slicer 3 has Calendar Year & Month (DimDate[CalendarYearAndMonth])
I tried the following: CACULATE(SUM(COST), ALLSELECTED(DimProject[ProjectName]), ALLSELECTED(DimTeam[ProjectManager]), ALLSELECTED(DimDate[CalendarYearAndMonth]) )
It didn’t work. Can anyone advise on what is the correct way to filter with multiple slicer values [from different tables] while using ALLSELECTED?