Running Total

[Anonymous]

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

[Icey]

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.

[themistoklis]

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

After the calculation, this is how the chart looks like

[themistoklis]

@Anonymous 

Also can you add the date field, the date value and running value in a table and share a snapshot with us so as to see how it looks like?

[themistoklis]

@Anonymous 

Can you share the workspace with us?

Mask any sensitive data