cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sj_ Frequent Visitor
Frequent Visitor

Help with DAX formula

Hi! 

 

Given two tables A (green) and B (blue), I need to fill out column B (complete/incomplete) based on Status column in table B. (See "Table A ID" - many to one relationship from table B to A) 

 

Table A - project 

Table B - task

 

Every project has 3 tasks tied. If all in scope tasks are reviewed, the project is complete. 

 

table A.PNGtable B.PNG

 

 

Expected Result : 

 

result.PNG

 

Can you help me with this? My goal is to show the % of complete projects. I will be able to get the % once I fill the complete column out.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Help with DAX formula

Try this:

 

Column = 
VAR __table = SELECTCOLUMNS(RELATEDTABLE('TableB'),"__status",[Status])
RETURN
IF("Open" IN __table,"Incomplete","Complete")

I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Help with DAX formula

Try this:

 

Column = 
VAR __table = SELECTCOLUMNS(RELATEDTABLE('TableB'),"__status",[Status])
RETURN
IF("Open" IN __table,"Incomplete","Complete")

I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

View solution in original post

Highlighted
sj_ Frequent Visitor
Frequent Visitor

Re: Help with DAX formula

Thank you so much!

Super User
Super User

Re: Help with DAX formula

Hi,

 

This picure should clarify my solution.

 

Untitled.png

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 279 members 3,085 guests
Please welcome our newest community members: