Running Total

[vaso]

Hi I have a table named 'Kartela' with posting date and amount i need to build a measure according to other solutions in the comunity but it does not completely work . When I keep the table simple it works

but when i add more info like the remarks of the movement is not working

any idea how to fix it ?

thea measure is

Running Total = Calculate ( SUM(kartela[blc]), FILTER( ALL('kartela'[Posting Date] ),'kartela'[Posting Date] <= MAX('kartela'[Posting Date])))

[powerbi_zone]

Running total can be easily achieved using the method shown in this video .Hope this helps .

https://youtu.be/NBGGHdKxupk

There is also a method  for a non date value : https://youtu.be/85sKPSnc_GE

[Jihwan_Kim · Accepted solution]

HI, I am not sure how your desired outcome looks like, but try something like below whether it suits your requirement.

It is the running total by Remarks.

Running Total =
CALCULATE (
    SUM ( kartela[blc] ),
    FILTER (
        ALL ( 'kartela' ),
        kartela[Remarks] = MAX ( kartela[Remarks] )
            && 'kartela'[Posting Date] <= MAX ( 'kartela'[Posting Date] )
    )
)