Forum Discussion

JoLambrichts's avatar
JoLambrichts
Regular Visitor
9 years ago
Solved

How to visualize these two Tables with a bridge table

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, re...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    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

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
JoLambrichts
Regular Visitor
9 years ago

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