Forum Discussion

yousef_alsalem's avatar
yousef_alsalem
New Member
2 years ago
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...
Need Help
  • ERD's avatar
    ERD
    2 years ago

    Did you create a measure? From your file: 

    Your screenshot shows a summarized column, not a measure.

     

yousef_alsalem's avatar
yousef_alsalem
New Member
2 years ago

It gives no result

:1023034i5BA7A9B07F2833B1:

 

 

ERD's avatar
ERD
Community Champion
2 years ago

Did you create a measure? From your file: 

Your screenshot shows a summarized column, not a measure.

 

  • yousef_alsalem's avatar
    yousef_alsalem
    New Member
    2 years ago

    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