Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

DAX IF OR with multiple conditions

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
7 years ago
Anonymous

I am not sure I correctly understood your issue.
Is this what you are looking for?

3 Replies

gpiero
Skilled Sharer
7 years ago
Anonymous

I am not sure I correctly understood your issue.
Is this what you are looking for?
- blodus
  Advocate IV
  2 years ago
  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
Community Champion
7 years ago
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.