Nested IF Statement with logical or condition

[damonkimble]

Hi All!

I created nested if statements that contain OR conditions. Example: IF a = 1 or b = 1, then "Pass" IF "a=2 or b=2", then "Fail", IF blank(), then "TBD". The problem is my result has "Pass" or "Fail", but "TBD" does not appear even though I have a lot of blanks.  For some reason, the blanks are coming as "Pass" but should be "TBD". Please see the screenshot and dax code below - thank you all!

FTC_Fail_Pass =

IF(Booking[brs_followupreason (groups)] = "Customers did not show up for meet"

|| Booking[brs_followupreason (groups)] = "Branch staff turned me away"

||Booking[brs_followupreason (groups)] = "Site not ready"

|| Booking[brs_followupreason (groups)] = "Vendor did not show up for meet",

"Fail",

IF( Booking[brs_followupreason (groups)] <> "Customers did not show up for meet"

|| Booking[brs_followupreason (groups)] <> "Branch staff turned me away"

|| Booking[brs_followupreason (groups)] <> "Site not ready"

|| Booking[brs_followupreason (groups)] <> "Vendor did not show up for meet"

|| Booking[brs_followupreason (groups)] <> "Need Part",

"Pass",

IF(Booking[brs_followupreason (groups)] = BLANK(),

"TBD"

)

)

)

[AlexisOlson · Accepted solution]

Note that the logical statement "a <> 1 || a <>2" is always true since if a <> 1 then the first case hold and, otherwise, if a = 1, then a <> 2 and the second case holds. This is why you never get to the "TBD" condition.

The negation of "a = 1 || a = 2" is not "a <> 1 || a <> 2" but rather "NOT ( a =1 || a = 2 )" = "a <> 1 && a <> 2".

I'd recommend rewriting your logic more compactly like this:

FTC_Fail_Pass =
IF (
    ISBLANK ( Booking[brs_followupreason (groups)] ),
    "TBD",
    IF (
        Booking[brs_followupreason (groups)]
            IN {
            "Customers did not show up for meet",
            "Branch staff turned me away",
            "Site not ready",
            "Vendor did not show up for meet"
        },
        "Fail",
        "Pass"
    )
)