Forum Discussion
Calculated Columns based on Hierarchy
Hello together, I would like to perform the following calculation in PowerBI using calculated columns: We have an organizational structure that can have any number of levels. For each organizati...
Here is the example file: https://1drv.ms/u/s!Al1J7v_eCkDwaT2pgfu1neluZFY?e=VuEf9H
Hi Anonymous ,
Have difficult about the logic.
Why the average of Organization ID 2 is (50+50)/2?
Where the second "50" from?
Best Regards,
Jay
Hi Anonymous,
thanks for looking at my issue.
The Average formula is: (Own Sales Value + Sum (Average of child units)) / (Count of Child units + 1)
So in the case of Organization 2 its is (50 (Own Value) + 50 (Value Organization 4)) / 2