cancel
Showing results for
Did you mean:
Helper I

## 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 and it worked properly.
The table name is : '6_RIE_couloir'

What i want to sum is : '6_RIE_couloir'[Sum E1+E2]

And minute by minute : '6_RIE_couloir'[Heure]

Here is a screenshot for a better explanation : (i've got 0 value at the begging in the column "sum E1 +E2" but there are plenty after that

Any ideas ?

Regards,

1 ACCEPTED SOLUTION
Helper I

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,
4 REPLIES 4
Super User II

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?

Helper I

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,
Super User II

If you clear the filter on Date then filter Heure to just 00:00:00 and 00:01:00, what shows up in the [Sum E1 + E2] column?

Helper I

Hello,

i forgot to put some context, the dataset in recording the flux of people through the day, generally people tend to come at 11/11:30 AM so the E1+E2 column have bigger value at that moment, if i filter between 00:00:00 and 01:00:00 that's what i get.

Edit : If i remove the Date filter, the chronology is broken.

Announcements