Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |