How to make a DAX "flag" column that holds 'Yes' when other columns hold 'Yes'

[Anonymous]

I am trying to replicate the below Tableau column in PowerBI DAX: 

That column will equal 'Yes' if any of the designated columns hold 'Yes' for each applicant.

I'm struggling to replicate this in PBI. My current code is not returned the expected results: 

Can anyone help?

[Anonymous]

Hi @Anonymous,

It's been a while since I've heard back from you and I wanted to follow up. Have you had a chance to try the solution that has been offered? If the issue has been resolved, could you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

[Tsrivastava · Accepted solution]

You can use 

Grade Discount =

var ConditionCount = IF(SELECTEDVALUE('Table'[Attainment Offer?])="Yes",1)+IF(SELECTEDVALUE('Table'[Sports Scholar?])="Yes",1)+IF(SELECTEDVALUE('Table'[A2B])="Yes",1,0)

return IF(ConditionCount>=1,1,0)

[Anonymous]

Thanks for your reply. Unfortunately this has increased the difference between the PBI and Tableau. See below: 

[lkalawski]

@Anonymous ,

The logic in Tableau is that if exactly one of the conditions is "YES", then the final result is also "YES". Otherwise it should be "NO".

Your code above does exactly the same, so the result should be correct without adding any changes.

Do you still see differences between Tableau and PBI? If you can create a sample dataset, it will be easier to verify.

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin

[lkalawski]

Hi @Anonymous ,

The Tableu code returns is if ONLY ONE of the conditions is YES. If it turns out that there are more YES, the code returns "No".

To make your code check if any factor is equal to "YES", please change the condition to:

RETURN
IF (ConditionCount >= 1, "YES", "NO")

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin