Running Total Measure with Filter

[Anonymous]

Hey guys,

I've got the following Measure:

Visits My Page = CALCULATE(

DISTINCTCOUNT('All Page Visits'[VISIT_ID]),

FILTER('All Page Visits','All Page Visits'[PAGE_URL]="https://my.page.nl/login")

Resulting in the following table:

But I'm trying to make a measure for the running total. I'm struggling due to the fact that I have a filter.
Is it possible to use the measure above in another measure?

With kind regards,

Önder

[Anonymous]

Wow Johnt75,

This helped me a lot. I really need to learn how to work with variables I guess...
Thanks a lot.

[johnt75 · Accepted solution]

yes, you could do something like

Running Total =
var maxDate = MAX('Date'[Date])
return CALCULATE( [Visits My Page], REMOVEFILTERS( 'Date'), 'Date'[Date] <= maxDate)