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])))

[Anonymous · Accepted solution]

Hi @vaso ,

I have created a simple sample, please refer to it to see if it helps you.

Modify the measure.

Running Total =
CALCULATE (
    SUM ( Kartela[bic] ),
    FILTER (
        ALL ( 'kartela' ),
        'kartela'[Posting Date] <= MAX ( 'kartela'[Posting Date] )
    )
)

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

[Fowmy]

@vaso 

Based on the measure, the amount shown in the 2nd imae is correct even with the remarks column aded. From where does the Remarks column come from? what is model relationship like?

Please share a screenshot of your model