Help with Average per team distribution

[Yes123]

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!

[Yes123]

I know it is slightly weird, but yes, that is how I need it.

[AlexisOlson · Accepted solution]

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] ) )
)

[Yes123]

One question though and I'm sure this a stupid one... It works fine, but why can't I have the [ProductAvg] as a VAR? Doing it that way it is slightly of

Measure =
VAR Per_Team = DIVIDE (
    SUM ( Sales[Amount] ),
    CALCULATE ( SUM ( Sales[Amount] ), ALLSELECTED ( Sales[Product] ) )
)
Return AVERAGEX(VALUES(Sales[Team]),Per_Team)

[AlexisOlson]

When you declare a variable, it is computed once and reused as a constant through the rest of the measure, so you'd be averaging the same value ignoring the Team.

[Yes123]

Awesome! Looks so simple, once you know. Thank you!

[AlexisOlson]

Why do you want ( (10/100) + (3/10) ) / 2 = 20% instead of the more standard average calculation (10+3)/(100+10) = 11.8%?