Forum Discussion
Anonymous
5 years agoNot applicable
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
- amitchandak
Super User
Anonymous , Try a measure like
Averagex(Values(Table[Country]), Calculate(Sum(Table[value])))
- AnonymousNot applicable
That works, thanks!