How to visualize these two Tables with a bridge table

Question

Hi community,I'm totally new in Power BI, so this may be a&nbsp;question with a simple answer.Suppose I have 3 tables:- Teachers&nbsp;(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&nbsp;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).&nbsp;RoomName 1RoomName 2RoomName 3RoomName 4RoomName 5TeacherName 1&nbsp;x&nbsp;x&nbsp;TeacherName 2&nbsp;&nbsp;&nbsp;x&nbsp;TeacherName 3xx&nbsp;&nbsp;&nbsp;should I use a matrix for this, or... ?Thank you all for your help.

v-huizhn-msft · Accepted Answer

Hi&nbsp;JoLambrichts,Please create relationship between&nbsp;Teachers and&nbsp;Reservations(one to many),&nbsp;Rooms and&nbsp;Reservations(one to many), then create a measure using the formula.
&nbsp;
count = IF(COUNT(Reservations[reservation])&gt;0,"Yes",BLANK())
I try to reproduce your scenario using the following sample tables.TeachersRoomsReservationsThe relationship I createdThen 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&nbsp;
&nbsp;
Best Regards,Angelia

Forum Discussion

How to visualize these two Tables with a bridge table

2 Replies

Related content

Bridge Table Dax Help

Bridge table

Bridge Table Inquiry

Data Modeling multiple value bridge tables

export from visual table

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