running total that changes with selection of year

[Giada90]

Hi,

I use this formula for running total:

Running total = calculate(sum(Orders[Sales]), filter(all('Date table calendar 2'), 'Date table calendar 2'[Date]<=max('Date table calendar 2'[Date] )))

but I need that running total changes if I change the selection of a year (for example if I select 2022 it starts from 1st of january 2022), how can I change the formula?

Thanks

[amitchandak · Accepted solution]

@Giada90 , use allselected

Running total = calculate(sum(Orders[Sales]), filter(allselected('Date table calendar 2'), 'Date table calendar 2'[Date]<=max('Date table calendar 2'[Date] )))

[Giada90]

THANKS!