Error in table totalling Averages

[Anonymous]

Hi, 

I am having an issue with the total of averages in my table reporting the incorrect amount, for example, I have: 

Region 1	Region 2	Total
127.76	266.93	144.85

There are other regions that have not provided figures (so are blank), but I wondered how the totalling was working to generate this number (144.85), and if there was a way to fix it? 

Thanks!

[lbendlin · Accepted solution]

it computed the average across your entire (well, selected) data. If that's not what you want then you need to define what formula you want (sum of averages sounds wrong too) and then implement that logic on the Totals level of your measure.

[Anonymous]

Ah - yes - sorry; I was looking at it and expecting the average of the two previous averages listed - but of course that's not how it works... 

My mistake!