Forum Discussion

damonkimble's avatar
damonkimble
Frequent Visitor
5 years ago
Solved

Nested IF Statement with logical or condition

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"
)
)
)
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    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"
    )
)

1 Reply

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    5 years ago

    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"
    )
)