Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |