SUMX and FILTER

[paris]

Hi All,

I would like to add one more filter to the DAX below.

TEST = SUMX(FILTER(SALES,SALES[YEAR]=CALENDER_YEAR[YEAR]),SALES[SALES])

I tried to add city but it does not work.

TEST = SUMX(FILTER(SALES,SALES[YEAR]=CALENDER_YEAR[YEAR]),FILTER(SALES,SALES[CITY]="TOKYO"),SALES[SALES])

Please help!

All the best,

Paris

[amitchandak · Accepted solution]

@paris 

If it a column

TEST = SUMX(FILTER(SALES,SALES[YEAR]= CALENDER_YEAR[YEAR] && SALES[CITY]="TOKYO"),SALES[SALES])

If it is a measure
TEST = SUMX(FILTER(SALES,SALES[YEAR]= max(CALENDER_YEAR[YEAR]) && SALES[CITY]="TOKYO"),SALES[SALES])

[paris]

Thank you very much for giving me two examples.

All the best,

Paris

[Greg_Deckler]

TEST = SUMX(FILTER(SALES,SALES[YEAR]=CALENDER_YEAR[YEAR] && SALES[CITY]="TOKYO"),SALES[SALES])