Total of average column in Matrix is incorrect

[Anonymous]

Hi, 

Please see below the example. In a table/matrix the total of average value (% Goal) is different from the real average.

Orders and customers are measures (SUM). % Goal (also a measure) is the division between orders and customers.

SALESMAN	Orders	Customers	% Goal
ERICK STEVEEN VELASQUEZ RENGIFO (PV3)	516	1018	50,69%
JANURY THAYRI VELASQUEZ RENGIFO (PV2)	526	910	57,80%
JONATHAN ANDRES SANTANA CARRILLOPV1)	463	1065	43,47%
JOSE ROLANDO GARCIA GARCIA	468	1241	37,71%
PARRAGA BAQUE JEAN CARLOS (MV1)	577	1237	46,65%
PORTILLA CARRILLO ANDERSON SNEHIDER(M3)	525	946	55,50%
	3075	6417	47,92%

Please your help

Thanks

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

I'd like to suggest you take a look at following link about measure total calculate issue:

Measure Totals, The Final Word  

If above not help, can you please share some dummy data for test?

Regards,

Xiaoxin Sheng

[Anonymous]

It worked

Thank you so much

[az38]

Hi @Anonymous 

3075/6417 = 0,4791958859280037

what result do you expect?

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Anonymous]

Hi, thanks for your reply

But, if I only show the % Goal column, the result is wrong. 

SALESMAN	% Goal
ERICK STEVEEN VELASQUEZ RENGIFO (PV3)	50,69%
JANURY THAYRI VELASQUEZ RENGIFO (PV2)	57,80%
JONATHAN ANDRES SANTANA CARRILLOPV1)	43,47%
JOSE ROLANDO GARCIA GARCIA	37,71%
PARRAGA BAQUE JEAN CARLOS (MV1)	46,65%
PORTILLA CARRILLO ANDERSON SNEHIDER(M3)	55,50%
	47,92%

[twintrbl]

I think what he's saying is that based on the numbers in your example, the calculation appears to be correct already - whether you show the other columns or not, the percentage for each person and the percentage of the total is correct, based on those numbers.  What number do you think you should be seeing in the % Goal total? Why do you think 47,92% is wrong, since the total numbers of 3075 sales and 6417 customers calculates to 47,92% of Goal?

[Anonymous]

Hi,

In a calculator, the average of % Goal is 48,63%, not 47,92%.

Your support is greatly appreciated