DAX IF OR with multiple conditions

[Anonymous]

Hello,

I have this formula in the custom column formula

 if(OR([AR Failure Mode 1] = [QC Failure Mode 1], 
       [AR Failure Mode 1] = [QC Failure Mode 2], 
       [AR Failure Mode 1] = [QC Failure Mode 3]), [AR Failure Mode 1])

However, the error Token RightParen Expected is showing up under the "R" where I have underlined. 

Why is this issue occuring?

[gpiero · Accepted solution]

@Anonymous 

I am not sure I correctly understood your issue.

Is this what you are  looking for?

[blodus]

Just when I thought PBI couldn't get any stupider.

Who comes up with these stupid OR() and AND() functions that are useless? 

Why would anyone ever use the stupid OR() and AND() functions when you can use || and && ?

[vivran22]

@Anonymous 

Hi,

The OR function in DAX evaluates only two conditions at a time. If you need to evaluate more than 2 conditions then use || instead of comma (,) and instead of OR function:

if(([AR Failure Mode 1] = [QC Failure Mode 1] ||
[AR Failure Mode 1] = [QC Failure Mode 2] ||
[AR Failure Mode 1] = [QC Failure Mode 3]), [AR Failure Mode 1])

Related article on OR: https://docs.microsoft.com/en-us/dax/or-function-dax

Hope this helps.

Thanks,

Vivek

PS: Please mark this as solution if this solves the purpose.