Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Running Total

I have a created date calculated column

Total sum requirements as a measure

I want to create a running total and replace the total sum requirements by running total

Unfortunately, the quick measure of running total doesn't return the correct results.

 

Here is the calculation

Total Requirements running total in Created 2 =

CALCULATE(

    [Total Requirements],

    FILTER(

        ALLSELECTED('SP Fit/Gap'[Created]),

        ISONORAFTER('SP Fit/Gap'[Created], MAX('SP Fit/Gap'[Created]), DESC)

    )

)

 

Here is the visual

 

 

Need Help

5 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion
    5 years ago

    Anonymous 

     

    Try any of the following 2

     

     

    Total Requirements running total in Created 2 =
CALCULATE (
    [Total Requirements],
    FILTER (
        ALLSELECTED ( 'SP Fit/Gap' ),
        'SP Fit/Gap'[Created] <= MAX ( 'SP Fit/Gap'[Created] )
    )
)

-- OR 

Total Requirements running total in Created 2 =
CALCULATE (
    [Total Requirements],
    FILTER (
        ALL ( 'SP Fit/Gap' ),
        'SP Fit/Gap'[Created] <= MAX ( 'SP Fit/Gap'[Created] )
    )
)

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      After the calculation, this is how the chart looks like

       

       

      • themistoklis's avatar
        themistoklis
        Community Champion
        5 years ago

        Anonymous 

         

        Can you share the workspace with us?

        Mask any sensitive data

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Try this:

    Total Requirements running total in Created 2 =
CALCULATE (
    [Total Requirements],
    FILTER (
        ALLSELECTED ( 'SP Fit/Gap' ),
        'SP Fit/Gap'[Sp or Gap] = MAX ( 'SP Fit/Gap'[Sp or Gap] )
            && 'SP Fit/Gap'[Created] <= MAX ( 'SP Fit/Gap'[Created] )
    )
)

     

    If this doesn't work either, please share me your .pbix file for test. Please remove sensitive information. It is suggested to upload your file to OneDrive for Business and then paste the link here.

     

     

    Best regards

    Icey

     

    If this post helps,then consider Accepting it as the solution to help other members find it faster.