Forum Discussion
DAX IF
Hello
I have a table similar to below. I would like a measure or add a column that tells me if the Live Support column has a TRUE Value in it in relation to the Account_ID.
So asking if Acccount_ID has TRUE value in the Live_Support column. Then returning yes or no.
Thank you
| Account_ID | Contact | Live_Support |
| 123 | ABC | FALSE |
| 123 | BCA | TRUE |
| 123 | CBA | FALSE |
Anonymous maybe add a measure using following expression:
Is True = VAR __true = CALCULATETABLE ( ALLEXCEPT ( Live, Live[Account_ID] ), Live[Live_Support] ) RETURN IF ( ISEMPTY ( __true ), "No", "Yes" )✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts 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.⚡
I believe you want the desired result regardless of Contact column, try the following measure:
Has True? = VAR check = CALCULATE ( CALCULATE ( DISTINCTCOUNT ( 'Table'[Account_ID] ), 'Table'[Live_Support] = TRUE () ), ALL ( 'Table'[Contact] ) ) RETURN IF ( check > 0, "Yes", "No" )I verfied it with a sample I created as per your provided sample:
3 Replies
Anonymous maybe add a measure using following expression:
Is True = VAR __true = CALCULATETABLE ( ALLEXCEPT ( Live, Live[Account_ID] ), Live[Live_Support] ) RETURN IF ( ISEMPTY ( __true ), "No", "Yes" )✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts 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.⚡
I believe you want the desired result regardless of Contact column, try the following measure:
Has True? = VAR check = CALCULATE ( CALCULATE ( DISTINCTCOUNT ( 'Table'[Account_ID] ), 'Table'[Live_Support] = TRUE () ), ALL ( 'Table'[Contact] ) ) RETURN IF ( check > 0, "Yes", "No" )I verfied it with a sample I created as per your provided sample: