Help with measure Var Max with 2 Filters

[cristianml]

Hi,

I need help with the following formula.  the Var X2  gives an error.  I need 2 filters under Max 

VAR x2 = SUMX(FILTER(ALLSELECTED('NWD_Table'),'NWD_Table'[FY & Q] = MAX('NWD_Table'[FY & Q]) & 'NWD_Table'[FY] = MAX('NWD_Table'[FY])-1),'NWD_Table'[NWD])

[amitchandak · Accepted solution]

@cristianml , Use double &

VAR x2 = SUMX(FILTER(ALLSELECTED('NWD_Table'),'NWD_Table'[FY & Q] = MAX('NWD_Table'[FY & Q]) && 'NWD_Table'[FY] = MAX('NWD_Table'[FY])-1),'NWD_Table'[NWD])