Cumulative Sales/ Running Totals not working

[Anonymous]

Hi,

I am trying to create cumulative sales(Running Totals) for a month,

this is the formula I am using to calculate cumulative sales 

# Cumulative Sales =

IF (

MIN ( Dates[Date] ) < TODAY (),

CALCULATE (

Sales[# Sales],

FILTER ( ALLSELECTED ( Dates ), Dates[Date] <= MAX ( Dates[Date] ) )

)

)

The formula is giving me the right results, But as you can see in the below image, when a single date is selected it is only incuding the sales of that day and not counting the previous sales

Not sure why it is doing it, if anybody encountered this before or is there any better way to calculate the cumulative sales?

Any help is much appreciated.

Many Thanks,

Prime

[Nathaniel_C]

Hi @Anonymous ,

Try changing ALLSELECTED () to ALL().

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel