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

[Anonymous]

Hi,

I'm stuck with an error: A table of multiple values was supplied where a single value was expected.

When I try to apply the New Column with measure as follows:-

Ownership = IF('Rejection'[DocumentType_Name]="SOP - Substitutions",LOOKUPVALUE('Help'[Group],'Help'[Rejection reason],'Rejection'[Rej_Reason]),LOOKUPVALUE('Help'[Group],'Help'[Rejection reason],'Rejection'[Rejection reason + activity]))

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous

Is this a MEASURE or Caclulated Column?

Simple Column References do not work in MEASURES

For example
IF('Rejection'[DocumentType_Name]="SOP - Substitutions"

should be written as

IF(selectedvalue('Rejection'[DocumentType_Name])="SOP - Substitutions"

[Anonymous]

Hi Zubair,

It is Caclulated Column.