Forum Discussion

vaso's avatar
vaso
Frequent Visitor
2 years ago
Solved

Running Total

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's avatar
    Anonymous
    2 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

  • 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