DAX IF

[Anonymous]

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

[parry2k · Accepted solution]

@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.⚡

[Anonymous]

Thank you both, 

They both worked for me.

[sm_talha · Accepted solution]

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:

[parry2k · Accepted solution]

@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.⚡