Forum Discussion

hyugo_v's avatar
hyugo_v
Helper I
5 years ago
Solved

Cumulative sum not working correctly

Hello everyone,   i'm trying to get a cumulative sum here but it looks like it doesn't consider the parameters i put in the dax formula. I've tried the same formula in a dataset i made up myself an...
Need Help
  • hyugo_v's avatar
    hyugo_v
    5 years ago

    I found the solution to my problem, i took the wrong parameter in the ALL fonction. 

    Here is the correct one :

    Cumulative = CALCULATE(
    SUM('6_RIE_couloir'[Sum E1+E2]),
    FILTER(ALL('6_RIE_couloir'[Heure]),'6_RIE_couloir'[Heure]<=MAX('6_RIE_couloir'[Heure])
    ))
     

    Regards,
jdbuchanan71's avatar
jdbuchanan71
Super User
5 years ago

So it is giving you what you are asking for.  The Sum of  the column [Sum e1+e2] where the Haure is <= the current row and ignore everything else.  

What are you wanting it to give you?  What should the number in the last column be for the highlighted rows?

 

hyugo_v's avatar
hyugo_v
Helper I
5 years ago

I found the solution to my problem, i took the wrong parameter in the ALL fonction. 

Here is the correct one :

Cumulative = CALCULATE(
SUM('6_RIE_couloir'[Sum E1+E2]),
FILTER(ALL('6_RIE_couloir'[Heure]),'6_RIE_couloir'[Heure]<=MAX('6_RIE_couloir'[Heure])
))
 

Regards,