Running Total without calculate?

[Applicable88]

Hello,

is there a way to compute running total without the calculate function? For example via creating a table variable inside a measure and sum it up via sumx?

With this sample data:

Date		Sales
01.01.2021		123
02.01.2021		423
03.01.2021		535
04.01.2021		66
05.01.2021		22
06.01.2021		11
07.01.2021		11
08.01.2021		33
09.01.2021		44

Thank you very much in advance. 

Best. 

[Greg_Deckler · Accepted solution]

@Applicable88 Yes:

Measure =
  VAR __Date = MAX('Table'[Date])
RETURN
  SUMX(FILTER(ALL('Table',[Date] <= __Date),[Sales])

[pstaggers]

Just me, or is there a missing paren in this?

Measure =

VAR __Date = MAX('Table'[Date])

RETURN

SUMX(FILTER(ALL('Table',[Date] <= __Date),[Sales])

[CNENFRNL]

No doubt, it's your most favooooooooorite way to kick off CALCULATE. 🤣