How to calculate project hours based on parent/Child relationship

[AlexBA]

Morning, 

I'm a new user to Power BI and have spent the morning trying to figure out how to calculate the total hours for the "parent" based on the hours of the "children".  I know the hours for each child, but need to sum them together to get the hours for the parent.  I could use some help. 

Any thoughts, suggestions, links, or examples are truly appreciated. 

Here is a highlight of the data provided. 

Thanks, Alex 

[v-chenwuz-msft]

Hi @AlexBA ,

In the table visual, power bi will calculate the hours automatically when you drag it to the values of its Values. O you can use the following measure to sum them.

Measure = SUM('Table'[Child Estimated Hours])

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexBA]

Morning and Thank you. 

I'm looking to do the breakdown within a table, not a visual, unfortunately.  On the breakdown, I need to be able to filter/sum the hours by the parent. I'll need to create a column that's the total of each Parent ID hours. 

For example, Parent ID 25240 should have a total of 190 hours since its children are 25241 (38 Hours) and 25245 (152 Hours). 

Maybe that question now is how to add a parent filter to your measure? 

Thanks, 

Alex 

[v-chenwuz-msft · Accepted solution]

Hi @AlexBA ,

Please try this code:

Column =
CALCULATE (
    SUM ( 'Table'[Child Estimated Hours] ),
    FILTER (
        'Table',
        [Parent Work Item Id] = EARLIER ( 'Table'[Parent Work Item Id] )
    )
)

Result:

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.