Filtering an AverageX function to calculate before a specific date

[Anonymous]

Hi, 

I am trying to create a measure that only calculates the sum before a specific date using the averageX function, could anyone advise me how I would specify this in the KEEPFILTERS part of the expression? I have been trying to simply put "<Date(2015,10,06)" after the (Master[Date]) and a few other things but nothing is working currently 

This is the function I currently have 

Order_Demand average per Date =

VAR VALUEZ = AVERAGEX(

KEEPFILTERS(VALUES(Master[Date])),

CALCULATE(SUM('Master'[Order_Demand]))

)

RETURN

IF(CONTAINS('SlicerTable', 'SlicerTable'[LineDescription], "Actuals"), VALUEZ, BLANK())

[amitchandak · Accepted solution]

@Anonymous , Try

VAR VALUEZ = AVERAGEX(
Filter(values(Master[Date]), Master[Date] <Date(2015,10,06)),
CALCULATE(SUM('Master'[Order_Demand]))
)

[Anonymous]

That worked, thanks very much. Not sure why I insisted on continuing with KEEPFILTERS