topic Re: Get the Sum of distinct count in DAX Commands and Tips

Get the Sum of distinct count

Pbrit — Fri, 08 Sep 2023 20:22:18 GMT

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.

Re: Get the Sum of distinct count

some_bih — Fri, 08 Sep 2023 21:13:30 GMT

Hi Pbrit try test measure below
Test =

SUMX(

VALUES(DimDate[Year]),

[Student Count Adm 4Yrs]

)

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

Re: Get the Sum of distinct count

Pbrit — Fri, 08 Sep 2023 21:21:51 GMT

some_bih Thank You,
This worked.