Forum Discussion
Solved
Getting selected Month from a slicer
Hi, I have issue with getting the selected value from a drop down list slicer. I have a mesure in the Months table to catch the select value in the slicer SelectedMonth = SELECTEDVALUE('Months'[M...
Did you create a measure? From your file:
Your screenshot shows a summarized column, not a measure.
ERD
Community Champion
Community ChampionOh, sorry, indeed, it will give an error since it's a measure. Try this:
EmpCount =
var mon = SELECTEDVALUE('Months'[MonthName])
VAR data =
CALCULATE(
COUNT(MainData[Employee Id]),
MainData[Business Unit] = SELECTEDVALUE(Joiners[Business Unit]),
MainData[Hiring Month] = mon
)
RETURN data
Theres is no slice for the business unit.
In the next step I will have to add more filters, like by year and quarter etc.
I have added a dummy file at the end of my post.