Getting error A table of multiple values was supplied where a single value was expected.

Hi Analitika ,

You can try using FIRSTNONBLANK(Tablename[Columnname], 1) instead of LOOKUPVALUE.

test=
CALCULATE (
FIRSTNONBLANK ( Tablename[Columnname], 1 ),
FILTER ( ALL ( Tablename), Tablename[UniqueID] = Table2 name[UniqueID2] )
)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.