Parent Child Hierarchy - Sum all Leafs on each NodeLevel
Hello everyone I hope you can help me with my Parent Child Hierarchy problem. I want to use a Dax measure to make the amount from the fact table (on hierarchy leaves) available on all node levels. The specialty is that I want to use the flat hierarchy column “Name” from the table “Hierarchy” in the visual. Without the following solutions: Using a hierarchy Lev1-3 or LevName1-3 in scope of the visual Calculation as a column and not as a separate dax measure In the attached picture you can see the test data and the desired result.
