Forum Discussion

Manar's avatar
Manar
Icon for Helper II rankHelper II
8 years ago
Solved

Pass multiple values from slicer into dax measure

Hi, I am trying to filter the count of submissions by year and months selected by user (slicer), I created a measure to get the count by year but in case of months, the end user can select multiple...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hey Manar

     

    I think replacing the "=" with "IN" will solve your problem, so instead of

     

    && Month( Submisions[Submission Date]) =  MonthValue 

    you might want to try

     

    && Month( Submisions[Submission Date]) IN  MonthValue 

    Let me know if that solves your problem.

     

    Hope this helps,

    Parker

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey Manar

 

I think replacing the "=" with "IN" will solve your problem, so instead of

 

&& Month( Submisions[Submission Date]) =  MonthValue 

you might want to try

 

&& Month( Submisions[Submission Date]) IN  MonthValue 

Let me know if that solves your problem.

 

Hope this helps,

Parker

Manar's avatar
Manar
Icon for Helper II rankHelper II
8 years ago

Anonymous that worked!! thanks!