Forum Discussion
Problems with SUMX
Hi Anonymous ,
Refer the formula.
Measure = SUMX(FILTER(ALLSELECTED(sheet1[Mes]),sheet1[Mes]<=MAX(sheet1[Mes])),[ind_rotacion])Best Regards,
Jay
Anonymous , Can you share sample data and sample output in table format? with based columns
try like
divide( SUMX(FILTER(ALLSELECTED(Sheet1),Sheet1[Mes]<=MAX(Sheet1[Mes])),Sheet1[ROTACION]) ,
COUNTX(FILTER(ALLSELECTED(Sheet1),Sheet1[Mes]<=MAX(Sheet1[Mes])),Sheet1[Contrato]))
Thank you so much for the quick response. I tryed the DAX fuction and it gave me zero. I think in there we would be acumulating the number of employees that quit divided by the monthly count of the employees. But i need to acumulate the result of that division. Sadly i cannot share an exact data sample, but i made one.
| Anio | Mes | cod_mes | Contrato | Nombre | Identificacion | ROTACION | fecha_mensual |
| 2021 | 1 | 20211 | 566687901 | peter parker | 111111111 | 0 | 1/01/2021 |
| 2021 | 2 | 20212 | 566687901 | peter parker | 111111111 | 0 | 1/02/2021 |
| 2021 | 3 | 20213 | 566687901 | peter parker | 111111111 | 0 | 1/03/2021 |
| 2021 | 4 | 20214 | 566687901 | peter parker | 111111111 | 0 | 1/04/2021 |
| 2021 | 5 | 20215 | 566687901 | peter parker | 111111111 | 0 | 1/05/2021 |
| 2021 | 6 | 20216 | 566687901 | peter parker | 111111111 | 1 | 1/06/2021 |
| 2021 | 1 | 20211 | 77889011 | samantha jhonson | 222222222 | 0 | 1/01/2021 |
| 2021 | 2 | 20212 | 77889011 | samantha jhonson | 222222222 | 0 | 1/02/2021 |
| 2021 | 3 | 20213 | 77889011 | samantha jhonson | 222222222 | 0 | 1/03/2021 |
| 2021 | 4 | 20214 | 77889011 | samantha jhonson | 222222222 | 0 | 1/04/2021 |
| 2021 | 5 | 20215 | 77889011 | samantha jhonson | 222222222 | 0 | 1/05/2021 |
| 2021 | 6 | 20216 | 77889011 | samantha jhonson | 222222222 | 0 | 1/06/2021 |
| 2021 | 1 | 20211 | 33300011 | peter parker | 333333333 | 0 | 1/01/2021 |
| 2021 | 2 | 20212 | 33300011 | peter parker | 333333333 | 1 | 1/02/2021 |
| 2021 | 1 | 20211 | 88888888 | john doe | 44444444 | 0 | 1/01/2021 |
| 2021 | 2 | 20212 | 88888888 | john doe | 44444444 | 0 | 1/02/2021 |
| 2021 | 3 | 20213 | 88888888 | john doe | 44444444 | 0 | 1/03/2021 |
| 2021 | 4 | 20214 | 88888888 | john doe | 44444444 | 0 | 1/04/2021 |
| 2021 | 5 | 20215 | 88888888 | john doe | 44444444 | 0 | 1/05/2021 |
| 2021 | 6 | 20216 | 88888888 | john doe | 44444444 | 0 | 1/06/2021 |
| 2021 | 1 | 20211 | 76514238 | john doe | 55555555 | 0 | 1/01/2021 |
| 2021 | 2 | 20212 | 76514238 | john doe | 55555555 | 0 | 1/02/2021 |
| 2021 | 3 | 20213 | 76514238 | john doe | 55555555 | 0 | 1/03/2021 |
| 2021 | 4 | 20214 | 76514238 | john doe | 55555555 | 0 | 1/04/2021 |
| 2021 | 5 | 20215 | 76514238 | john doe | 55555555 | 1 | 1/05/2021 |
this is kinda what i have the total of employees varies each month and i have a dummy column with a 1 in the month they rotated so i sum those ones and count the total of contracts and then i divide it getting the ind_rotation measure. In a table an add the month the sum of the rotation, the count of the contracts and the ind_rotation measure and it gaves me the monthly indicator which i need to accumulate
I need another measure to acummulates the ind_rotation in order to add it to the table. also i need it to be this way cuz i need to filter by zone and management office
This would be the output table
| count of contracts | sum of rotation | ind_rotation | accum ind_rotation |
| 1277 | 15 | 1,17% | 1,17% |
| 1322 | 18 | 1,36% | 2,54% |
| 1332 | 24 | 1,80% | 4,34% |
| 1331 | 31 | 2,33% | 6,67% |
| 1363 | 21 | 1,54% | 8,21% |
| 1371 | 12 | 0,88% | 9,08% |