populating a colmnn based on the aggregate of a number of rows expressed as a %

[Anonymous]

So, i have 2 models Tasks and Subtasks, in each model I have pulled in data from a 3rd model which contains the weight of the task and subtask.

What i need to do is populate the task model with the total work completed from the children subtasks

Input - Subtasks

key	parent	Status	Weight	Value
12345	11111	in progress	10	0
23456	11111	new	75	0
34567	11111	done	5	5
45678	11111	done	75	75
56789	11111	done	10	10
54321	12345	in progress	5	0
43210	12345	done	75	75

Output - not sure what the best thing to do here is, as I want to work out the % of work completed - Tasks Model

Key	Status	Value(from subtasks) %
1111	in progress	51.42
12345	in progress	93.76

Thanks in advance for any information on how to do this.

[Anonymous]

@amitchandak thanks, i took the first one and after messing around a while realised it worked and was looking at the data incorrectly.

[amitchandak · Accepted solution]

@Anonymous , In this this should a new measure

Divide(Sum(Table[Value]), Sum(Table[Weight]))

or

Divide(Calculate(Sum(Table[Weight]), Filter(Table,Table[Status]="Done"))  , Sum(Table[Weight]))