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

[Anonymous]

Hello all,

here is my problem. I don't know how this happened. Can someone please help me? I have used this function many times, but this error is the first. I found every time it matches, it will say multiple values. 

Thank you 

[PabloDeheza]

Hi there!

If you are working on a measure then your code wont work because you are missing a function like MAX() or SELECTEDVALUE() on the column you are using, in this case 'Nonconformance...'[NC Initiate Corrections]. Eitherway, your code should work on a calculated column.

Let me know if my answer was useful!

[Anonymous]

Hi @PabloDeheza 

Thanks for replying. Do you mean I should do this?

NC Use As Is = SWITCH(TRUE(), SELECTEDVALUE('Nonconformance UAI w/ Supplier Grid'[NC Initiate Corrections])= "Use-As-Is"

, "Use As Is", "Not Use As Is")

But this not works. I'm sure I have Use-As-Is in my data, however, this code only returns Not Use As Is