Is it possible to Count the number of registrations by student without having to create a calculated table?
What I have setup from my ‘Registrations’ table is a calculated table using the following:
Completed Courses = SUMMARIZE(‘Registrations’,‘Registrations’[Student ID],‘Registrations’[Term - Academic Plan No Roll-up], ‘Registrations’[Academic Year], ‘Registrations’[Term Academic Career], Registrations[Gender Description], Registrations[Age Groups], “Completed Courses”, COUNTA(‘Registrations’[Student ID]) )
My goal is to get “Completed Courses” by student and then be able to use things like, Academic Year (to see the number of courses completed in a given year), Gender, Age Group, Academic Career, Academic Plan, to see if there are any patterns between any of these factors and the number of completed courses.
I have this information by using a Calculated Table, I just didn’t know if there is a better approach in getting this.