Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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