How to visualize these two Tables with a bridge table

[JoLambrichts]

Hi community,

I'm totally new in Power BI, so this may be a question with a simple answer.
Suppose I have 3 tables:
- Teachers (Id, Name)
- Rooms (Id, Name)
- Reservations (TeacherId, RoomId, reservation date)
Quite simple, a teacher can make a reservation for a room, so one teacher has many rooms, and one room has many teachers.
If a reservation is made, it creates a record in the reservation table.
What I want is a visualization of ALL teacher (as rows) with ALL rooms (as columns), and an indication whether there was a reservation (just a checkmark or the reservation date).

	RoomName 1	RoomName 2	RoomName 3	RoomName 4	RoomName 5
TeacherName 1		x		x
TeacherName 2				x
TeacherName 3	x	x

should I use a matrix for this, or... ?
Thank you all for your help.

[v-huizhn-msft · Accepted solution]

Hi @JoLambrichts,

Please create relationship between Teachers and Reservations(one to many), Rooms and Reservations(one to many), then create a measure using the formula.

count = IF(COUNT(Reservations[reservation])>0,"Yes",BLANK())

I try to reproduce your scenario using the following sample tables.

TeachersRoomsReservationsThe relationship I created

Then select the Tearchers[Name] as rows, the Rooms as column, the count measure as value. Set the rows and columns to show items with no data, so all the tearchers and rooms names can show.

Expected results 

Best Regards,
Angelia

[JoLambrichts]

Thank you for this perfect answer.
Still a lot to learn for me.