Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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]))
Solved! Go to 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"
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"
Hi Zubair,
It is Caclulated Column.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |