LOOKUPVALUE - A table of multiple values was supplied where a single value was expected

[jcooksnappy1]

Dear Forum

I'm trying to insert a calcultead column into my table using two search criterias, and the formula is as follows:

 = LOOKUPVALUE('COGS (inc VAT)'[PRODUCT COGS*],'COGS (inc VAT)'[Wesite Name],mergedInvoiceRevenue[website_nm],'COGS (inc VAT)'[Cobrand Name],mergedInvoiceRevenue[cobrand_nm])

I have checked that there are no duplictae PROD_ID's but I'm still getting an error messgae to say ''a table of multiple values was supplied where a single value was expected''. The expected result is the far right column on the top table.

Can anyone help me overcome this problem - I have attached a screenshot of the table setup for both tables.

Many Thanks

[jcooksnappy1 · Accepted solution]

Thanks @Zubair_Muhammad, appreciate your help.

The formula does not error, but returns blank values for all instances? Any ideas?

[Zubair_Muhammad]

Hi @jcooksnappy1

Try this one

=
CALCULATE (
    FIRSTNONBLANK ( 'COGS (inc VAT)'[PRODUCT COGS*], 1 ),
    FILTER (
        'COGS (inc VAT)',
        'COGS (inc VAT)'[Wesite Name] = mergedInvoiceRevenue[website_nm]
            && 'COGS (inc VAT)'[Cobrand Name] = mergedInvoiceRevenue[cobrand_nm]
    )
)

[Anonymous]

@Zubair_Muhammad , thanks!

You've saved my day today!

Perfect!

[jcooksnappy1 · Accepted solution]

Thanks @Zubair_Muhammad, appreciate your help.

The formula does not error, but returns blank values for all instances? Any ideas?

[jcooksnappy1 · Accepted solution]

Thanks @Zubair_Muhammad it did solve it, the table was just updating.

Many Thanks