Cumulative Sum of a Measure (no dates)

[jure_rak]

Hello,

I sorted my data into intervals and have now measure that calculates a probability for a given interval. The table looks like this:

So, I need a new column that would show for the interval 5 the value of 0,06 + 0,18, etc.

Thanks,

Jiri

[amitchandak]

You should able to use earlier 

https://docs.microsoft.com/en-us/dax/earlier-function-dax

Or this example on time, but should work on your case too (Lookup)

https://community.powerbi.com/t5/Desktop/Getting-the-sum-of-the-previous-datetime-value-in-report/td...

[jure_rak]

Thanks, I will give it a try, below the picture again, I realized it got lost from the main message.

[v-chuncz-msft · Accepted solution]

@jure_rak 

You may use DAX below to add a measure.

Measure =
VAR i =
    MAX ( 'Table'[Interval] )
RETURN
    SUMX (
        FILTER ( ALLSELECTED ( 'Table'[Interval] ), 'Table'[Interval] <= i ),
        [Probability]
    )

[jure_rak]

You´re genius, it works.

Jiri