Forum Discussion
Help with Average per team distribution
Okay, so I have searched for a solution but have not been able to solve it. I guess I should use AverageX, but how is the question?
Might just be easier to look at the picture below. So I have a sales amount per team and product. After creating a % within each team I want the Average of all teams.
I have dimensions for Date, Team and Product (if needed).
Thanks in advance!
You can aggregate subtotal averages rather than a standard average like this:
AVERAGEX ( VALUES ( Sales[Team] ), [ProductAvg] )where [ProductAvg] is whatever measure you already have defined, presumably something like
DIVIDE ( SUM ( Sales[Amount] ), CALCULATE ( SUM ( Sales[Amount] ), ALLSELECTED ( Sales[Product] ) ) )
6 Replies
Why do you want ( (10/100) + (3/10) ) / 2 = 20% instead of the more standard average calculation (10+3)/(100+10) = 11.8%?
I know it is slightly weird, but yes, that is how I need it.
You can aggregate subtotal averages rather than a standard average like this:
AVERAGEX ( VALUES ( Sales[Team] ), [ProductAvg] )where [ProductAvg] is whatever measure you already have defined, presumably something like
DIVIDE ( SUM ( Sales[Amount] ), CALCULATE ( SUM ( Sales[Amount] ), ALLSELECTED ( Sales[Product] ) ) )Awesome! Looks so simple, once you know. Thank you!
