Get Total for Current Row Year

[johnfa]

Hi All  

Thought this would be simple but ...... I am trying to write a DAX expression which returns the total of field Activity for the current row year derived from a Date column in table1 which joins to a Dates table. This expression just returns a total for all years ignoring the current Calendar Year any idea whats wrong ?

Current Year Activity = CALCULATE(SUM('table1'[Activity]), ALLEXCEPT(Dates, Dates[CalendarYear]))

Here is what it looks like in a table display

Any help appreciated

[Anonymous]

Use sumx() instead of sum.

Sumx is an iterative function.

Thank,
Pravin