running total measure on graph, slicing by time looks odd

[katie1234]

Hi,

I've created a running total measure with the following formula:

Running Realised Cost = 
CALCULATE (
    SUM ( test_data_powerbi[Realised Cost] ),
    FILTER (
        (ALLSELECTED( test_data_powerbi[Issue Date] )),
        test_data_powerbi[Issue Date] <= MAX ( test_data_powerbi[Issue Date])
    )
)

It looks good with slicers by category...

But when I'm playing with the date it bazzes:

Do you know how to avoid this? Feel like it would be a common problem. I can also provide the .pbix and data if needed

Thank you!

Katie

[v-lid-msft · Accepted solution]

Hi @katie1234 ,

Could you please try the following measure?

Running Realised Cost = 
CALCULATE (
    SUM ( test_data_powerbi[Realised Cost] ),
    FILTER (
        ALLSELECTED(test_data_powerbi),
        [Issue Date] <= MAX ( test_data_powerbi[Issue Date])
    )
)

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[katie1234]

Thank you @v-lid-msft! Works like a charm 😄

[AlB]

yes. The pbix would definitely help