Forum Discussion

JMWDBA's avatar
JMWDBA
Icon for Advocate II rankAdvocate II
9 years ago

Graduates and Registrations

So I have two tables  Graduates Registrations The table 'Graduates' has the following fields: Student ID Number Academic Level Academic Degree Degree posting Date The table 'Registrations...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
9 years ago

JMWDBA,

 

Better to show us the expected output. Check the DAX below first.

Table =
SUMMARIZE (
    Registrations,
    Registrations[Academic Year],
    "Count", DISTINCTCOUNT ( Registrations[Student ID] )
)