IF Statement LookupValue A table of multiple values was supplied where a single value was expected

[Anonymous]

Hi,

I have been using the following function for months but today when i refreshed my report in desktop it brought up the error A table of multiple values was supplied where a single value was expected.

This is the formula;

(IF(LOOKUPVALUE('Input'[Amount],'Input -'[Oppy ID],Data[ Berry ID])=0,Data[Converted Amount],LOOKUPVALUE('Input'[Amount],'Input'[Opportunity ID],Data[Berry ID])))

Thanks,

[v-juanli-msft]

Hi @Anonymous 

If you have many ['Input -'[Oppy ID] corresponding to one single Data[ Berry ID], it would throw an error as your see before.

If this case, please define a aggregation for the mutiple values.

If you have problems, please feel free to tell me.

It is appreciated to share some data examples and expected results.

Best Regards

Maggie