topic Re: SUMX using Year Function in DAX Commands and Tips

SUMX using Year Function

584100 — Thu, 30 Jan 2020 18:03:34 GMT

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

Re: SUMX using Year Function

az38 — Thu, 30 Jan 2020 18:22:31 GMT

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

Re: SUMX using Year Function

Anonymous — Thu, 30 Jan 2020 18:41:55 GMT

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