Forum Discussion

schoden's avatar
schoden
Post Partisan
6 years ago
Solved

multiple values was supplied for single value error

Hi All,    I couldnt get a better solution to return multiple values. I want to return all of  employee names , filter date of join as this month    New measure= CALCULATE(VALUES [emp name], MON...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi schoden ,

     

    Do you want a visual or a table?

    If you want a visual, please create a measure like below and add it to visual filter.

    Measure = IF(MONTH(SELECTEDVALUE('Table'[date]))=MONTH(TODAY()),1,0)

    If you want a tbale, please check the formula below.

    Table 2 = FILTER('Table',MONTH('Table'[date])=MONTH(TODAY()))

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

schoden's avatar
schoden
Post Partisan
6 years ago

Tahreem24sorry I dont have dummy data 

amitchandak's avatar
amitchandak
Super User
6 years ago

schoden , Please make sure all table column are mentioned correctly

CALCULATE(count(Table [emp name]), MONTH(Table[date])= MOnth(Today()))