Calculating project progress

[GrimReaperX]

Hello,

I have a data where i have projects and subprojects. Projects include several subprojects and each subproject has status like Completed, In progress and Not started. I would like to calculate how much % of the specific project is completed based on statuses from subprojects?

How can i use DAX in this purpose?

Thank you. 

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.

[GrimReaperX]

I cannot share data but can give an example.

i have hundreads of projects and each project is divided into tasks and actions.

Project A has 5 tasks and 4 actions. 

Task1, Task 2 are completed, other 3 tasks are in progress. Action 1,2,3 are in progress and 4th is completed.

Project B has 4 tasks and 4 actions. 2 of the tasks are not started while other 2 are completed. 3 actions are completed and 1 is in progress. Based on that, i want to calculate how much percent of each project is completed. 

[Alex_Sawdo]

You would most likely need two caclulations somewhere in your report, one calculating a numerator value and one calculating the denominator value. The numerator would be something like this:
CALCULATE(
      COUNT(
           [Your Project ID]
     ),
     FILTER(
           [Your Project Table],
           Status = "Completed"
     )
)

Then, your denominator measure would be the same but without the FILTER function. Then, one more measure for the final calculation:
CALCULATE(
     DIVIDE(
           Numerator,

           Denominator
     )
)

This would show the total % of completed projects.