Excluding running total from date filter context

[RMDNA]

Hi all,

Quick question about keeping a running total unfiltered (but still visually limited) when a date slicer is applied. 

I have a visual here with a running total line (orange). In January of 2021, the total users were just over 32,000. The running total code is below:

Spoiler

Running Total = 
CALCULATE(DISTINCTCOUNT(Table1[users]),
    FILTER(
        ALLSELECTED(Table1),
        Table1[date] < MAX(Table1[date])
    )
)

However, when I filter the date axis, that number drops to 250. 

What I'm looking to do is still visually focus on that time period (Jan - June 2021), but keep the count of total users unaffected (e.g. show 32,000 - 33,000 over that same period).

[Vera_33 · Accepted solution]

Hi @RMDNA 

Have a try

Running Total = 
CALCULATE(DISTINCTCOUNT(Table1[users]),
    FILTER(
        ALL(Table1[date]),
        Table1[date] < MAX(Table1[date])
    )
)