Forum Discussion
Having problems with relationships
I have the following relationships.
Appointment has 1 Clinic
Patient has 1 Clinic
I'm trying to create a cube that has the patient and their count of appointments.
However when I get the appointments filtering down on the patient. They are totals (Patient A, 20, Patient B, 20, etc.) My first instinct obviouls would be to create a relationship between the Patient and Appointments as 1 Patient has many Appointments.
However when I try and do this it says there is an ambigious relationship because of the clinic relationship. I would think the BI would use that relationship to filter the correct appointments but it doesn't. How do I approach solving this issue?
Thank you in advance.
1 Reply
- AnonymousNot applicable
Hi mweel111 ,
Regarding your question, can you say what fields are in both tables? By which fields are the two tables connected? When creating table-to-table relationships.It is better to have a star model consisting of a fact table with multiple dimension tables.
Model relationships in Power BI Desktop - Power BI | Microsoft Learn