SUMX using Year Function

[584100]

Amount = SUMX (FILTER(Sales,(YEAR(Sales[Date]=2014))),Sales[Sales Amount])

Above formula is calculating sum of column [Sales Amount] without filtering rows having value only 2014. I just want to have sum of rows for which Year in [Date] column is 2014. Any idea why is it not considering filter condition.

Thanks in advance!!

Chetna

[Eboones908]

CALCULATE(SUMX(sales,salesamount),salesdate="2014")

[az38 · Accepted solution]

Hi @584100 

First, you have an issue with parenthesys YEAR function: YEAR(Sales[Date]=2014) is completely wrong statement

Second, try to use ALL() inside filter

Amount = SUMX (FILTER(ALL(Sales),YEAR(Sales[Date])=2014),Sales[Sales Amount])

do not hesitate to give a kudo to useful posts and mark solutions as solution