Solution for reconciliation of data at Node levels - Hierarchial data set

[InsHunter]

Hi, Being a Newbie requesting suitable solution and a suitable viz for presenting hierarchial data analysis.
Source data set sample as below.

Created the structure as below in POWER BI

Now request help to arrive at an analysis format like below which shall help to find the variance at all Nodes which are Parent/Grand Parent/Great grand parent (except only child nodes) like a drill down to each child level where the aggregation happens.

Prepared the data set with calculated columns as per enclosed PBIX file and struck there to proceed further.

https://drive.google.com/file/d/11an1tuJt5ColpEHwAe7AR4yjVi180PB7/view?usp=share_link

Deeply appreciate your timely help.Thank you.

[v-binbinyu-msft]

Hi @InsHunter ,

I'm a little confused about your needs, Could you please explain them further? 

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[InsHunter]

Thanks for your response.

Objective of this excercise is to reconcile the data under 'Values' column. The data capturing points are child nodes which can be either only a child or may be a parent (for the next level)  as well as child. The realtime data is captured at all nodes and parent node data need to be equal to aggregated child node data. In Practical situation this may not match and thro reconcilation to find the loss intensityand quantify the same against all Parent nodes.Hope i could make some clarity by the above statements.

Best regards,