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

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.

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
2 years ago

Actually there is, and you can see it on your screenshot:

 

  • yousef_alsalem's avatar
    yousef_alsalem
    New Member
    2 years ago

    It gives no result

    :1023034i5BA7A9B07F2833B1:

     

     

    • ERD's avatar
      ERD
      Icon for Community Champion rankCommunity 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