Forum Discussion
Aggregating on Parent Child Hierarchies
I am looking to aggregate Immediate children values to display next to the parent Node.
Can anyone provide me a pattern to do this calculation in simplistic fashion possible in PowerBI desktop. However, love to hear alternatives too.
We are looking to count the number of conversations by a supervisor( parent Node) with direct reports (Immediate Children Not an aggregation of all the nodes under a supervisor hierarchy) .
What I need to do in PowerBI is a Hierarchial aggregation at every level with depth+1 except for the leaf. what is the best approach in PowerBI?
what I need:
| CountOfConversationswithDirectReports | ||||
| Stan | 2 | |||
| Michael | 1 | |||
| Redick | ||||
| Devin | 2 | |||
| Tom | ||||
| patrick |
From the above example : - Stan had 2 conversations with his direct reports which is sum of his conversations with Michael and Devin. Michael had 1 converstion with Redick and hence the value 1 next to his name.
Any help is appreciated.
OK, check out attached, not sure it is what you want. How do you plan on getting your hierarchy from the information you provided? Table2 in the file.
4 Replies
I am looking to aggregate Immediate children values to display next to the parent Node.
Can anyone provide me a pattern to do this calculation in simplistic fashion possible in PowerBI desktop. However, love to hear alternatives too.
We are looking to count the number of conversations by a supervisor( parent Node) with direct reports (Immediate Children Not an aggregation of all the nodes under a supervisor hierarchy) .
What I need to do in PowerBI is a Hierarchial aggregation at every level with depth+1 except for the leaf. what is the best approach in PowerBI?
what I need:
From the above example : - Stan had 2 conversations with his direct reports which is sum of his conversations with Michael and Devin. Michael had 1 converstion with Redick and hence the value 1 next to his name.
Any help is appreciated.
- Greg_Deckler
Community Champion
Can you provide sample source data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Key ParentKey Conversations Stan null Michael Stan 1 Devin Stan 1 Redick Michael 1 Tom Devin 1 Patrick Devin 1 Sample data for the summation of supervisor conversations I listed in my previous post.
