MAX FOR CUSTOMER

[twins2019]

HELLO
I HAVE THE FOLLOWING SITUATION.

A	B	C	D	E	F	G	H
Customer Number	Country (0 = No Risky; 1= Risky)	Index of payment2	Rating (0 = A,B; 1= C,D,E,F, no rating)	Insurance limit (0 = yes insurance; 1= no insurance)	(B-A) > 0 is 1 <0 is 0:	RISKY OVERDU Y is 1 empty is 02	total rec on cl2
AE00001	1	0	0	1	1	0	0
AE00006	1	0	0	1	0	0	0
BE00011	0	1	0	1	1	1	0
BE00011	0	1	0	1	1	1	0
BE00035	0	1	0	1	1	1	0
BE00218	0	1	0	1	1	1	0
BE00218	0	1	0	1	1	1	0
BE00218	0	1	0	1	1	1	0
BE00297	0	1	0	1	1	0	0
BE00303	0	1	0	1	1	1	0
BE00396	0	1	0	1	1	1	0
BE00396	0	1	0	1	1	1	0
BE00568	0	1	0	1	0	1	0
BE00568	0	1	0	1	0	1	0
BE00568	0	1	0	1	0	1	0
BE00569	0	1	0	1	0	1	0
BE01155	0	0	0	1	0	0	0
CA00036	0	1	0	1	1	1	0
CA00110	0	0	0	1	1	0	0

I NEED A FORMULA THAT GIVE ME THE SUM OF COLUMN B-C-D-E-F-G BY CUSTOMER (FOR EXAMPLE TOTAL BE00568=3) AND THEN I NEED THAT THIS SUM IS DIVIDED FOR THE COUNTING OF ALL CUSTOMERS.

CAN YOU HELP ME ? 

[santiagomur]

try this creat an index in the table and this measure.

total = var total=SUM(Hoja5[B])+SUM(Hoja5[C])+SUM(Hoja5[D])+SUM(Hoja5[E])+SUM(Hoja5[F])+SUM(Hoja5[G])
var cont=COUNT(Hoja5[A])    

return
DIVIDE(total;cont)

[twins2019]

i give another example

yes

for example i have these datas 

A             B C D E F G H
AE00001 1 0 0 1 1 0 0
AE00006 1 0 0 1 0 0 0
BE00011 0 1 0 1 1 1 0
BE00011 0 1 0 1 1 1 0

in my pivot i need a colum that give me BY customer MAX of the sum of all column B C D E F G H

here the result 

Customer Number	total
AE00001	3
AE00006	2
BE00011	4

and then i need another mesure that give me the SUM of this new column "TOTAL" dived by the number of the customer (in this case 9/3 

thanks to all

[santiagomur · Accepted solution]

USE THE SAME MEASURE 

total = var total=SUM(Hoja5[B])+SUM(Hoja5[C])+SUM(Hoja5[D])+SUM(Hoja5[E])+SUM(Hoja5[F])+SUM(Hoja5[G])
var cont=COUNT(Hoja5[A])    

return
DIVIDE(total;cont)

here the result