cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ecamburn
New Member

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:

ecamburn_0-1611427871390.png

 

 

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?

 

 

 

1 ACCEPTED SOLUTION
iXpert_info
Advocate I
Advocate I

Hey @ecamburn 

You should be able to setup your activities as below

iXpert_info_0-1611428637231.png


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

Best Regards
Jay Patel
iXpert Analytics

View solution in original post

2 REPLIES 2
ecamburn
New Member

That worked. Thanks Jay @iXpert_info 

iXpert_info
Advocate I
Advocate I

Hey @ecamburn 

You should be able to setup your activities as below

iXpert_info_0-1611428637231.png


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

Best Regards
Jay Patel
iXpert Analytics

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.