Calculated groups DAX error

[Anonymous]

Hello - can anyone tell me why this DAX is not working when i use to try and create a calculation group...? Thanks in advance!

VAR date =
MAX ( BO_data[Reference_Date] )
VAR LastDec =
DATE ( YEAR ( ( date ) - 1 ), MONTH ( 12 ), DAY ( date ) )
VAR RESULT =
CALCULATE (
SELECTEDMEASURE (),
FILTER ( 'Calendar', 'Calendar'[Date] <= LastDec )
)
RETURN
RESULT

[amitchandak · Accepted solution]

@Anonymous , try like

VAR _date =
MAXX (allselcted( BO_data), BO_data[Reference_Date] )
VAR LastDec = DATE ( YEAR ( ( _date ) - 1 ), 12 , DAY ( _date ) )
VAR RESULT =
CALCULATE (
SELECTEDMEASURE (),
FILTER (all( 'Calendar'), 'Calendar'[Date] <= LastDec )
)
RETURN
RESULT

if needed remove all from calendar