Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Adding a Total to matrix

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 , Try a measure like

     

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

2 Replies

  • Anonymous , Try a measure like

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    That works, thanks!