Forum Discussion
Continued ContributorNested OR function and separate question on HTML for this forum
I'm happy to close this one off. The issue wasn't with the formula but with the logic.... This is the correct way of doing what we wanted to do:
Condition Met = IF(AND (UserC = "" , OR(ID = "", OR(ID = "none", ID = "specific string"))), "Option 1", "Option 2")
In essence UserC has to be blank and then the other criteria come into play. We were using OR on all of them.
Continued Contributor
Firstly, thank you for confirming the issue with the forum - good to see I'm not the only one who has these issues!
As for the DAX, your formula appears to be identical to mine, apart from the == and using BLANK () instead of "".
Here are the two, side by side, if I take out my double == and change your BLANK () to "":
Condition Met = IF(OR (UserC = "" , OR(ID = "", OR(ID = "none", ID = "specific string"))), "Option 1", "Option 2")
Condition Met = IF(OR (UserC = "" , OR(ID = "", OR(ID = "none", ID = "specific string"))), "Option 1", "Option 2")
I have also tested it with your version, using BLANK() and it's the same result.
The == is called "Strict equal to", and is different that single = in that it considers blanks as equals as well. As per Microsoft.
Community ChampionThank you for the info. Let me reconstruct it.
Condition Met = IF(
OR (
ISBLANK(UserC),
OR(
ID == "",
OR(
ID == "none",
ID == "specific string"
)
)
),
"Option 1",
"Option 2"
)
make sure that you write none and specific string as it is saved in the data. it is case sensitive.