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.
Did you create a measure? From your file:
Your screenshot shows a summarized column, not a measure.
Thank you it's working now
EmpCountMeasure =
var selectedMonth = SELECTEDVALUE('Months'[MonthName])
var selectedYear = SELECTEDVALUE('Years'[Year])
var data =
CALCULATE(
COUNT(MainData[Employee Id]),
MainData[Business Unit] = SELECTEDVALUE(Joiners[Business Unit]),
MainData[Hiring Month] = selectedMonth,
MainData[Hiring Year]= selectedYear
)
RETURN data