Adding a Total to matrix

[Anonymous]

Hi Everyone,

As I see, when adding a 'row subtotals' In a matrix, that's automatically doing the Total according to the value's formula.

for example, this is my row data - 

I created a matrix that presents the AVERAGE per country, but in Total, I need the SUM of these averages (the 88 is the average of all values, I want it to be 361 instead of 88), is that possible?

Thanks!

[Anonymous]

That works, thanks!

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

Averagex(Values(Table[Country]), Calculate(Sum(Table[value])))