How to create subtotals for hierarchical data?

[alvaroiramirez]

Hi,

I am new to Power BI and I am having trouble creating a report based on data extracted from Azure DevOps. This is the way data is structured:

[1]: /answers/storage/temp/250218-table.jpg

I need to get totals by:

- User Story
- Bug
- All User stories per feature
- All bugs per feature
- Feature (all its user stories & bugs per feature combined)
- Epic (all its features combined)
- Everything (all epics)

I tried using Power Query Editor / Group By (ribbon button) but Parent ID is not listed. Another option I thought were developing a program in Python to calculate these subtotals and update the table, but it will be more work each time the data is updated.

How can I get the values I need?

Many thanks in advance.

[Ashish_Mathur]

Hi,

Show the exact result that you are expecting.

[alvaroiramirez · Accepted solution]

Thank you, Ashish. Unfortunately I could not find the answer in your websites. What I did was to link the same data source 4 times and rename them as Task, Story, Feature and Epic. Then, I linked those tables using work item id -> parent work item id. That created an inner join that now lets me summarize the tasks at any level (stories, features and epics). Hopefully this works for other folks.