Forum Discussion
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...
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 , 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
