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...
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