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")

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

Proud to be a Datanaut!


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")

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

Proud to be a Datanaut!


sj_ Frequent Visitor
Frequent Visitor

Re: Help with DAX formula

Thank you so much!

Highlighted
Super User
Super User

Re: Help with DAX formula

Hi,

 

This picure should clarify my solution.

 

Untitled.png