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

[unclejemima]

I've got this formula for a calculated column..

LongDescription = lookupvalue(LComment[CommentLine],LComment[InvUniqueRecordNo],Inventry[InvUnique])

I'm getting the error "A table of multiple values was supplied where a single value was expected."

I'm fairly sure there is only unique values in the LComment[InvUniqueRecordNo] and Inventry[InvUnique] columns.  Is this what the error is referring to?

Is there a different formula I could use?  Or something I need to change for formatting?  Say make both Text or something?

Thanks!

[Zubair_Muhammad · Accepted solution]

@unclejemima

Give it a shot

LongDescription =
CALCULATE (
    FIRSTNONBLANK ( LComment[CommentLine], 1 ),
    FILTER ( LComment, LComment[InvUniqueRecordNo] = Inventry[InvUnique] )
)