Problem calculation Rolling total for Non-date fields

[Anonymous]

Hello,

I have issue in calculating the rolling Sum total for "Total Value Change" coulmn.

I need dynamic cummulative total. The measure which I am using is:

TEST For Running Total =

VAR CurrentValueChange = [Total Value Change]

VAR MaterialsWithSales = ADDCOLUMNS ( ALLSELECTED ( 'CURRENT KEKO'[Material Number (Trimmed)] ),"@Values", [Total Value Change])

VAR MaterialsWithHigherSales = FILTER ( MaterialsWithSales, [@Values] >= CurrentValueChange )

VAR Ranking = COUNTROWS (MaterialsWithHigherSales)

VAR FinalResult = SUMX ( MaterialsWithHigherSales, [@Values] )

Return

FinalResult

  
-> This DAX is not working and It is difficult to find the Rolling total. This measure Works if we use it only for Card. 
Example of card: 

This matches the total but when I drag this formula to the Table, it throws error. 

Thanks!

[parry2k]

@BITomS I would avoid earlier, can be super slow.

[BITomS]

Hi @Anonymous ,

There is an answer here: https://javierguillen.wordpress.com/2012/02/06/can-earlier-be-used-in-dax-measures/

Hope this helps.

[parry2k]

@Anonymous I think you are looking for a running total by material number, check this video on how you can achieve this using new DAX functions: How new WINDOW DAX functions makes running total super easy in Power BI - YouTube