cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PoweredOut20
Resolver I
Resolver I

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_IDContactLive_Support
123ABCFALSE
123BCATRUE
123CBAFALSE
2 ACCEPTED SOLUTIONS
parry2k
Super User
Super User

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






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

sm_talha
Resolver II
Resolver II

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_0-1631038743047.png

 

View solution in original post

3 REPLIES 3
PoweredOut20
Resolver I
Resolver I

Thank you both, 

They both worked for me.

sm_talha
Resolver II
Resolver II

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_0-1631038743047.png

 

View solution in original post

parry2k
Super User
Super User

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






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!