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.

     

amitchandak's avatar
amitchandak
Super User
6 years ago

schoden , You have to use it like this

New measure= CALCULATE(max [emp name], MONTH(date)= MOnth(Today()))

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

 

or use firstnonblank on emp name.

 

If you trying to filter emp name. Use this measure along with emp name in a visual, it will filter it in the visual

schoden's avatar
schoden
Post Partisan
6 years ago

amitchandak  Hi 

 

Yes I tried all , gives same error 😞

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    schoden  ,

     

    Could you please share some dummy data to test your scenario if possible.

    • 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()))