DAX IF OR with multiple conditions

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.