Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Running Total Measure with Filter

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/l...
  • johnt75's avatar
    johnt75
    4 years ago

    yes, you could do something like

    Running Total =
var maxDate = MAX('Date'[Date])
return CALCULATE( [Visits My Page], REMOVEFILTERS( 'Date'), 'Date'[Date] <= maxDate)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Wow Johnt75,

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