Cumulation of the same value doesnt work

[JANSAN]

Can you help in PowerBi. I made measures which do what they have to do mostly, but there is one thing off about that. I give you my measures:

Bruch (kg) = SUM('Unpivoted Bruch'[AnzahlBruch(kg)])

 Cumulative Total = VAR cumulativbruch = [Bruch (kg)] RETURN CALCULATE( [Bruch (kg)], FILTER( ALLSELECTED('Unpivoted Bruch'[Material_Bruch]), [Bruch (kg)] >= cumulativbruch ) ) 

The second measure cumulatitve total gives the cumulated values of Bruch(kg).

The one problem I have now is that if there are 2 values of Bruch(kg) which are the same, then the second (same) value wont get cumulated. Example: 1000, 500, 500 My Cumulativ table would give me: 1000,1500,1500 this is wrong I need to fix that.

[amitchandak]

@JANSAN , Try with window function give a second argument

example

Cumm Based on net = CALCULATE([Net], Window(1,ABS,0,REL, ADDCOLUMNS(ALLSELECTED('Item'[Brand]), "_net", [Net]),ORDERBY([_net],DESC, [Brand])))