topic Running Total in Report Server

Running Total

vaso — Sat, 13 Jan 2024 21:30:18 GMT

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

Re: Running Total

Fowmy — Sun, 14 Jan 2024 07:42:13 GMT

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

Re: Running Total

Anonymous — Tue, 16 Jan 2024 02:49:38 GMT

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