Originally I had an Average Course Take Rate formula of:

**Average Course Take Rate = AVERAGE(‘Completed Courses’[Completed Courses])**

Then I realized that the number remained the same even when I would change the academic year so I knew something had to be wrong with using that formula. so it showed 3.76 as the average course rate for all 5 academic years.

Now I have the Average Course Take Rate Formula Of:

**Average Course Take Rate = [Total Registrations]/[Unique Registered Student]**

Where:

**[Total Registrations] = SUM(‘WW Registrations’[Course Registration])**

and

**[Unique Registered Student] = COUNTROWS(VALUES(‘WW Registrations’[Student ID]))**

Which now responds appropriately to the academic year filter when changing from one year to another. But I feel as though I am missing something but I can’t put my finger on exactly what. I appropriately want the formula to take the average number of registrations (courses taken) per year by students.

I think its an evolution in my learning as well about DAX and using measures in the formulas instead of always using the source columns directly.