Forum Discussion

annade22's avatar
annade22
New Member
7 years ago
Solved

Calculate average subprojects grouped by parent project

Hi, My organization has a KPI that follows the number of subprojects that are created at one single time. That is measured by the number of project id:s per parent project. I need to both count the ...
Need Help
  • annade22's avatar
    annade22
    7 years ago

    After long search, I found a solution that works. If anyone wants to use it here it is:

     

    Count of Projects_ProjectID average per Projects_ParentProject =
    AVERAGEX(
        KEEPFILTERS(VALUES('NumberProjects'[Projects_ParentProject]));
        CALCULATE(COUNTA('NumberProjects'[Projects_ProjectID]))
    )
annade22's avatar
annade22
New Member
7 years ago

After long search, I found a solution that works. If anyone wants to use it here it is:

 

Count of Projects_ProjectID average per Projects_ParentProject =
AVERAGEX(
    KEEPFILTERS(VALUES('NumberProjects'[Projects_ParentProject]));
    CALCULATE(COUNTA('NumberProjects'[Projects_ProjectID]))
)