Create new column with "0" or "1" based on 3 columns in same table

[baneworth]

Hello Community,

I need to write a DAX and never wrote before and can not get my head around it.

Could you please help.

I have 3 inputs

   - Checkpoint OK = 0 or 1

   - Checkpoint Not OK = 0 or 1

   - Checkpoint Not Used = 0 or 1

But now there can the be situation that all 3 of them have 0's.

In that case i want to create a measure or column that gives me "Checkpoint Open"

- if all 3 above are 0's then CHeckpoint open needs to be "1"

- if one of them has a 1 then CHeckpoint open needs to be "0"

I can also provide some example data if needed.

Best regards

Mat

[parry2k · Accepted solution]

@baneworth add a new column with the following expression:

Checkpoint Open = 
IF ( Table[CheckPoint Ok] = 0 && Table[Checkpoint Not Ok] = 0 && Table[Checkpoint Not Used] = 0, 1, 0 )

or

Checkpoint Open = 
IF ( Table[CheckPoint Ok] + Table[Checkpoint Not Ok] + Table[Checkpoint Not Used] = 0, 1, 0 )

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[baneworth]

Thanks @parry2k 

worked like a charm, appreciate it