Get the Sum of distinct count

[Pbrit]

Dear Community Members,

I have a dax calculation that gets the count of students that were admitted 4 years ago.

My challenge is how to sum it, the result gives me the last value as the total instead of the sum of each row.

Please find my DAX query below:

Student Count Adm 4Yrs =
CALCULATE(
DISTINCTCOUNT(Admissions[AUGSTNO]),
DATEADD(DATESYTD(DimDate[Date]),-4,YEAR),
USERELATIONSHIP(Admissions[AUGSTNO],Graduation[GSTNO])
)

What I expect is the total to be the sum of the Student Count Adm 4yrs for each year.

Any direction to resolve this would be appreciated. 
Table showing the last value as the total

[Pbrit]

@some_bih Thank You, 
This worked.

[some_bih · Accepted solution]

Hi @Pbrit try test measure below
Test =

SUMX(

VALUES(DimDate[Year]),

[Student Count Adm 4Yrs]

)

Did I answer your question? Kudos appreciated / accept solution!