Forum Discussion
Multi value selection from slicer
Hi, I'm struggling to wrap my head around this. Any help will be appreciated. I have a report which uses measures that requires user input from from 2 different slicers as shown below. ...
Hi Emmy66 - can you try the below dax code and modify as per your tables and columns
Payment =
VAR vYears = VALUES(Calendar[Year])
VAR vQtrs = VALUES(Calendar[Quarter])
RETURN
CALCULATE(
[Amount],
FILTER(
FactTable,
FactTable[Year] IN vYears &&
FactTable[Quarter] IN vQtrs
)
)
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
rajendraongole1 Thanks for your prompt response. I tried it out but it still returned blank. The reason I had the 1st & 2nd variables in my request is to give me the flexibility to create different measures using either 2 years + or 2 years behind i.e. 2022 or 2026.