Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Calculate Hierarchy Levels

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 shoul...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

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