Scoring overall completion

[amirghaderi]

I have Table A with Workpack List. Table B shows link of Work pack to documents with their status 'Completed" or "In progress". I want to have a visual which give me the completion score of each work pack. if all documents linked to a work pack are completed, the workpack score is 100%. example as below.

Table1			Table2					Report
Workpack			Workpack	Doc	Doc Status	Forecast Date		Worpack	Overall Status	Doc Count	latest Doc date
A			A	FF	Complete			A	100%	4
B			A	GG	Complete			B	25%	5	15/10/2023
			A	HH	Complete
			B	RR	Complete
			B	HH	In Progress	5/05/2023
			B	TT	Complete
			B	OO	In Progress	10/05/2023
			B	PP	In Progress	15/10/2023

[Ahmedx · Accepted solution]

1) the number of documents A will be 3, not 4
2) the number of documents B will be 5, but here the number is Complete will be 2, and therefore the percentage will be 40%, but not 25%
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26Rh2PwawPkeSg4hmLQ?e=QoejU4

[amirghaderi]

Thanks for the help!