Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 Ac...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

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

  • sm_talha's avatar
    sm_talha
    4 years ago

    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:

     

sm_talha's avatar
sm_talha
Resolver II
4 years ago

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: