Performance problems with 1:M relationship

[JimJim]

Hi Guys,

I have a performance issue with one of my reports and one particular graph hangs before I eventually have to cancel it.

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. 

I have the following measure which runs instantly 

Completed Count = 
SUM('Service Appointment'[Completed])

However, when I attempt to show the completed service appointments for each technician, the query doesn't complete and times out.

Is there another way I could remodel this?

[Anonymous]

Hi @JimJim ,

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  

In addition, you can also take a look at below blog about relationship directions:

What is the Direction of Relationship in Power BI? 

Regards,

Xiaoxin Sheng