A table of Multiple values was supplied where a singe value was expected - Using SUMX LOOKUPVALUE

[aftermath85]

Hello,

We have a measure that is :

Actual Pallets Received =

SUMX('Inbound',

'Inbound'[QUANTITY] / LOOKUPVALUE(

Excel[pcs per pallet],

Excel[Part No],

'Inbound'[PART_NO]

))

Inbound = Excel document that does not have duplicates for anything and does not have a zero value anywhere.  This formula only breaks once in awhile.  The Inbound document is updated weekly then PowerBI is refreshed.  We validated all data on excel to be correct. Have no idea why it keeps doing this.  Help!

[miTutorials]

This generally happens when you have more than one value in the result column name, you might want to double check that.

Please see this video - may be it will help.

Error while using LOOKUPVALUE function in PowerBI ? Watch this | MiTutorials

Best regards,

Ismail | MiTutorials

MiTutorials on YouTube Explore over 200+ Power BI tutorials and enhance your skills!

[aftermath85]

Thank you, I can't even see the results column from this formula, it just errors out.  The dataset (excel doc) it's pulling from 3 people looked through it the past week, nothing 😞