DAX If(or( - More than two conditions

[jakeryan56]

Hi there.

I am just trying to do a simple If(or( measure but I have three conditions and this formula only accepts two conditions.

I would make a calculated column, but in this situation that won't work because this is all based on other measures.

Here is essentially what I would like:

Platinum Invoice Warning = if(or([Tech Bar Basic]>=3,[Tech Bar Intermediate]>=3),[Tech Bar Complex]>=3),"Warning","-")

[Zubair_Muhammad · Accepted solution]

@jakeryan56

Try this alternative

Platinum Invoice Warning =
IF (
    [Tech Bar Basic] >= 3
        || [Tech Bar Intermediate] >= 3
        || [Tech Bar Complex] >= 3,
    "Warning",
    "-"
)