Forum Discussion

Socrates's avatar
Socrates
Frequent Visitor
6 years ago
Solved

Set overall status if all tasks completed

I have a table where multiple people could be assigned to one project, but even if one person's part is complete the whole project is still live until everyone is done. For instance:   Project I...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Socrates - Should be something like:

    Column =
  VAR __Table = SUMMARIZE(FILTER('Table',[ProjectID]=EARLIER([ProjectID])),[Status])
RETURN
  IF(MAXX(__Table,[Status])="Completed" && COUNTROWS(__Table)=1,"Completed","Live")
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

You asked for a calculated column.  A measure would be slightly different.

 

Completed = 
var p = Projects[Project ID]
var s = CALCULATETABLE(VALUES(Projects[Status]),ALL(Projects),Projects[Project ID]=p)
return switch(TRUE(),countrows(s)>1,FALSE(),s={"Completed"},TRUE(),FALSE())