Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

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,

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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