Project Status from Multiple Status

kpeterson 

you can try this

Column = if(countx(FILTER('Table','Table'[Regular Phase]=EARLIER('Table'[Regular Phase])),'Table'[Regular Phase])=COUNTX(FILTER('Table','Table'[Regular Phase]=EARLIER('Table'[Regular Phase])&&'Table'[Status]="Complete"),'Table'[Regular Phase]),"Complete","In progress")

pls see the attachment below

Hi kpeterson 

There are my steps in PQ to achieve a goal 

1. I duplicated the table

2. Removed from the new table all columns except for code and status :

3 Grouped the code by statuses and counted distinct rows

4. Merged this new table with the original:

6. created a conditional column that checks how many distinct statuses have code and if it is "complete"

7. removed unnecessary column of counting and switched off the loading to the model the table that i created for grouping

Result

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Thank you for your reply and this worked really well. Thanks!

Thank you for your reply.  After some QC, I also need to add a line for "if all Not Started" then Not Started.  Is that possible to add? TIA!