Need your help with a measure

[Luukv93]

Hello,

I'm trying to understand of the following measure: (30 Day Running Total).

1. I would say there are 2 row contexts: Total sales has row context because of the previously used formula SUMX, and FILTER generates a row context.

2. How does the FILTER, ALL and MAX logic work?

Your help is much appreciated

30 Day Running Total = 
CALCULATE( [Total Sales];
	FILTER( ALL( Dates );
		Dates[Date] > MAX( Dates[Date] ) - 30 &&
		Dates[Date] <= MAX( Dates[Date] ) ) )

Total Sales was calculated with measure:

Total Sales = SUMX( Sales; Sales[Quantity] * RELATED( Products[Current Price] ) )

[v-yulgu-msft]

Hi @Luukv93,

Here are some blogs for your reference:

Filter context in DAX

ALL DAX function

Best regards,

Yuliana Gu