Connected the rank column with the total average of completion timeline

[Ayx11]

Hello, 

The goal is to connected the rank with the total average of completion timeline

I have grouped all the status then created by on the status. 

The total average of completion is based on calculation of average total value. 

E.g. 

Status	Group Status	RANKX (ALL(table),'table'[Group Status),, ASC, Dense)
C01	C01	1
C02	C01	1
C03	C01	1

Result 

When I click on the C01 status then I will see the value of the calculated total average of completion date. 

Thank you so much. 

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

[Ayx11]

Where I am stuck is that I cannot find the right dax measure/calculation. The goal I want is that when i select a any status then the average will appear. 

[lbendlin]

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.