Calculate Sum of Average

[Henley678]

I want to create a measure to calculate Sum of Average (Weighted Instock in the image).

In the attached image - on Week 201949:

Weights (a measure) = Current Sales (for each Country Name) / Total Sales (all countries' Current Sales on 201949)

Total for Weights equals sum of all Weights (100%)

Avg Instock% is a column

Total for Avg Instock% equals average of all Avg Instock%

Weighted Instock = Weights * Avg Instock

Total for Weighted Instock at bottom still shows 94.7%, which is not correct, since I want to have sum of all Weighted Instock%.

Could any one advice how to create a measure to perform this function (sum of average)?

Thanks a lot,

Henry

[amitchandak · Accepted solution]

@Henley678 , Create a measure like this and use

sumx(summarize(Table, Table[Week], Table[Country Name], "_1",[Weighted Instock]),[_1])

[Henley678]

@amitchandak , thanks for the solution.

To follow up: what function does [_1] in the equation stand for?

[stevedep]

It a label for the expression. 

[Henley678]

@stevedep , make sense. Thanks a lot.