Percent of Tasks Complete by Person

[JAXX]

I apologize if this is really easy for everyone here, but I am struggling to establish a % Completed based on goal vs. actual.

			Running total:	75%
	May		June
Person	Goal	Completed	Completion %	Goal	Completed	Completion %
a	1	0	0%	1	1	100%
b	1	1	100%	1	0	0%
c	1	1	100%	1	2	100%
d	1	0	0%	1	1	100%
e	1	2	100%	1	1	100%
f	1	1	100%	1	1	100%
		% Completed Goal	67%		% Completed Goal	83%

The completion % and the running total completion % are what I am struggling with.  Do I need to create a new summary table to do this or can I do it with a couple measures?  Thanks in advance for your help.

[v-danhe-msft · Accepted solution]

Hi @JAXX ,

You could refer to below formula to calculate completion%:

Completion% = IF(CALCULATE(SUM(Table1[Completed]))/CALCULATE(SUM(Table1[Goal]))>=1,1,0)

Result:

But I wonder how about the logic of your running total completion %: 75%

Could you please offer me more information about it?

Regards,

Daniel He

[JAXX]

Sure thing.  Thanks for your response.

The 75% completion is actually based on the number of people that have completed their goal rather than the actual number completed/the actual goal number.  In the example I provided, 4 out of 6 people completed their goal for May, which would equate to 67%, 5 out of 6 people completed their goal for June which is 83%.  The running total would be 9 out of 12 people completing their goal, which would be 75%.