Getting Running Total in matrix, based on Measure

[niculeica]

Hello,

Having some troubles calculating Running Total of a measure, in a matrix (so the running total would be based on a measure, not column). Expected result is running total being summed in the following cadence:

	Amount	Total
Jan	10	10
Feb	30	40
Mar	60	100
Q1	100	100
Apr	30	130
May	25	155
Jun	20	175
Q2	75	175

The existing measure is below:

_Renewal amount = SUMX(SUMMARIZE(_Timeline,_Timeline[_M],"Renewal ARR",[_Renewal amount raw]),[Renewal ARR])

Any ideas on how this could be achieved?

[Anonymous · Accepted solution]

Hi @niculeica ,

Please have a try.

_Renewal amount running total =
CALCULATE (
    [_Renewal amount],
    FILTER (
        ALLSELECTED ( _Timeline[_M] ),
        ISONORAFTER ( _Timeline[_M], MAX ( _Timeline[_M] ), DESC )
    )
)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.