Get count of assignments in courses

[power-bi-noob]

I have two tables (courses, assignments) that are related by the course id. I can easily create a table showing a list of courses and all of the assignments in each course. What I'd really like to do is have a table that shows the number of assignments in each course.

So instead of:

course 1, assignment 1

course 1, assignment 2

course 1, assignment 3

course 1, assignment 4

course 2, assignment 1

course 2, assignment 1

I'd like:

course 1, 4

course 2, 2

What sort of DAX magic would I need to make this happen? Thanks!

[johnt75 · Accepted solution]

Create a measure like

Num assignments = COUNTROWS(Assignments)

and add that to a visual with the course name column from the courses table.

[power-bi-noob]

All that does is add a 1 at the end of each assignment, so now I get:

course 1, assignment 1, 1

course 1, assignment 2, 1

course 1, assignment 3, 1

course 1, assignment 4, 1

course 2, assignment 1, 1

course 2, assignment 1, 1

[johnt75]

remove the assignment name column from the table visual

[power-bi-noob]

I actually just figured that out a split second after my post. Thanks!