multiple values was supplied for single value error

[schoden]

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], MONTH(date)= MOnth(Today()))

error : multiple values supplied error.

I tried using MAX, FIRSTNONBLANK, SELECTEDVALUE = all same error. 

[v-jayw-msft · Accepted solution]

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]

@v-jayw-msft Thanks for your effort:D it solved.    

I have another problem :  I want to customise week number from any start date for example;

Date_start  = 29/09/2019,  30/09/2019, 5/10/2019 and so on 

   WeekNum=1,1 ,2  and so on 

Please share me your idea . Thanks 

[amitchandak]

@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]

@amitchandak  Hi 

Yes I tried all , gives same error 😞

[Tahreem24]

@schoden  ,

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

[schoden]

@Tahreem24sorry I dont have dummy data 

[amitchandak]

@schoden , Please make sure all table column are mentioned correctly

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