DAX formula to cumulative values based on a column

[Anonymous]

I need a formula for the Cumulative of the "Minut" evety time we change the event number.

EVENT  Minut     Cumulative

97            2           5

97            3           5

98           18        24 

98            2         24

98            1         24

98            3         24  

99            6         11

99            4         11

99            1         11

What is the recommended simple DAX for such operation?

[PaulDBrown · Accepted solution]

@Anonymous 

If you wish to see all the rows, you will need to add an index column to your table (otherwise the values get aggregated by "Event")

The try this measure to get the aggregate for each event:

Total by Event = CALCULATE([Sum of Minut]; ALLEXCEPT(Table1; Table1[Event]))

To get the actual cumulative :

Cumulative = CALCULATE([Sum of Minut];
            FILTER(ALL(Table1);
            Table1[Event]<=MAX(Table1[Event]))
            )

And this is the result:

[v-yiruan-msft · Accepted solution]

Hi @elmorlc,

You can create one measure as below:

Cumulative = CALCULATE(SUM('Events'[Minut]),ALLEXCEPT('Events','Events'[EVENT]))

Best Regards

Rena

[PaulDBrown · Accepted solution]

@Anonymous 

If you wish to see all the rows, you will need to add an index column to your table (otherwise the values get aggregated by "Event")

The try this measure to get the aggregate for each event:

Total by Event = CALCULATE([Sum of Minut]; ALLEXCEPT(Table1; Table1[Event]))

To get the actual cumulative :

Cumulative = CALCULATE([Sum of Minut];
            FILTER(ALL(Table1);
            Table1[Event]<=MAX(Table1[Event]))
            )

And this is the result:

[amitchandak]

Create a new column

New column = sumx(filter(table,table[EVENT]=earlier(table[EVENT])),table[Minut])

Appreciate your Kudos.