Forum Discussion
Cumulative Total ... help!!
Hi all, please note that I am trying to do the following (after 6 hours of failures) Cumulative Sum of Total Commission / Tot Employee.. Acumulado Empleado Month 1 ... 861K/ 2035 Acumula...
Anonymous , Almost the same time update. This because Avg is at the day level not at month level
Try like
Acumulado empleado = calculate(divide(
CALCULATE(SUM('2019'[COMISION TOTAL]), filter(ALL('2019'), '2019'[Mes fecha]<=MAX('2019'[Mes fecha]))),
averagex(summarize(Table,Table[Mes Nomber],"_sum",CALCULATE(sum('2019'[TOTEMP]),filter(ALL('2019'), '2019'[Mes fecha]<=MAX('2019'[Mes fecha])))),[_sum])
)
)
You can use allselected too.
thank you sooo much!