Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Helper II
Helper II

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
Helper II
Helper II

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.