Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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.

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous 
Put this calculation individually and check which one is not working. 

To me, this is working as Avg employee will remain almost same and the numerator is increasing and your calculation of "Acumulado empleado " is increasing.

 

You can also try

Acumulado empleado = calculate(divide(
CALCULATE(SUM('2019'[COMISION TOTAL]), filter(ALL('2019'), '2019'[Mes fecha]<=MAX('2019'[Mes fecha]))),
CALCULATE(average('2019'[TOTEMP]),filter(ALL('2019'), '2019'[Mes fecha]<=MAX('2019'[Mes fecha])))))

amitchandak's avatar
amitchandak
Super User
6 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    thank you sooo much!