Aggregating on Parent Child Hierarchies

[zmayari]

           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. 

[zmayari]

           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]

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

[zmayari]

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. 

[Greg_Deckler · Accepted solution]

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.