Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
Solved! Go to 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
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)
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
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |