Performance problems with 1:M relationship

Question

Hi Guys,&nbsp;I have a performance issue with one of my reports and one particular graph hangs before I eventually have to cancel it.&nbsp;I have attached a simplified ERD which shows the report model, the relationship between Service Appointment and Assigned Resource is where I believe the problem lies. The relationship is 1:M as multiple technicians may be assigned to one service appointment.&nbsp;&nbsp;&nbsp;I have the following measure which runs instantly&nbsp;&nbsp;Completed Count = 
SUM('Service Appointment'[Completed])&nbsp;However, when I attempt to show the completed service appointments for each technician, the query doesn't complete and times out.&nbsp;Is there another way I could remodel this?

anonymous · Answer

Hi&nbsp;JimJim&nbsp;,
How did your chart design? Can you please share some detail information to help us clarify your scenario?
How to Get Your Question Answered Quickly &nbsp;
In addition, you can also take a look at below blog about relationship directions:
What is the Direction of Relationship in Power BI?&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

Performance problems with 1:M relationship

1 Reply

Related content

USERELATIONSHIP problems with n:m-relationship

PBI Embedded performance problem

One to Many Relationship Problem

Relationship

Problem with inactive relationships