Power BI Calculate Hierarchy Levels

[Anonymous]

Good day Power BI gurus,

Please will you suggest me how should i perform calculations (SUM) on hierarchy levels.

Herewith example:

Please note,
If I choose "C" in the slicer, it should calculate (SUM) "C"  value, which is 25 and it's connected levels ("H", "R"),values respectedly 29, 40

If I choose "A" in the slicer, it should calculate (SUM) "A"  value, which is 10 and it's connected levels ("A", "B"),values respectedly 15, 25

Please will you provide solution / DAX accordingly

Thank you

Kind Regards

[v-piga-msft]

Hi @Anonymous ,

Based on your description, I could understand your requirement correctly.

If it is convenient, could you share your original table structure so that I could have a test on it?

In addition, you could have  a reference of the similar threads below.

https://community.powerbi.com/t5/Desktop/Manager-Level-Hierarchies-with-multiples-in-Power-BI/td-p/322302

https://community.powerbi.com/t5/Desktop/Dynamic-measure-calculation-for-hierarchy-data/td-p/592546

https://community.powerbi.com/t5/Desktop/Sum-Hierarchy-Levels-based-on-selection/td-p/477855

Best  Regards,

Cherry