Forum Discussion

ecamburn's avatar
ecamburn
New Member
5 years ago
Solved

Relationships between 3 tables

I have data on teachers that measures multiple activities per day for multiple days.  My data model includes 3 tables—teachers, days, activities. The data are all normalized. Here are the ID variables:

teacherid uniquely identifies rows in the teacher table (stored in all 3 tables)

teacherdayid uniquely identifies rows in the day table (stored in days and activities tables)

Power BI detects these relationships:

activities table (many) to days table (one) via teacherdayid

teachers table (one) to activities table (many) via teacherid

teachers table (one) to days table (many) via teacherid

The third relationship is not selected by default. When I try to select it I get this error:

 

 

Power BI will permit either relationship 2 or 3, not both simultaneously.

The problem I’m running into is that I have a dashboard with visuals that need all 3 relationships to be active simultaneously (for example, there’s a display that joins data from teachers to activities and another display that joins data from teachers to days).

Is there any way to have active relationships between these 3 tables simultaneously?

 

 

 

  • Hey ecamburn 

    You should be able to setup your activities as below


    Did I answer your question? If yes Please mark this as solution

    Best Regards
    Jay Patel
    iXpert Analytics

2 Replies

  • Hey ecamburn 

    You should be able to setup your activities as below


    Did I answer your question? If yes Please mark this as solution

    Best Regards
    Jay Patel
    iXpert Analytics