Creating relationship problem in PowerBi

Hello Gökberk Uzuntaş,

Appreciate your time on this.

I have disabled the many to many relationship, because it was not doing what i wanted and tried different approaches. The deal value is a New and Existing Sales SUM measure i have in F_SCC_Ticket_and_Inquiries table. The idea is to show the business impact of the escalations by getting the deal value from F_SCC_Ticket_and_Inquiries table throught the Opportunity ID. The point is that in F_SCC_Ticket_and_Inquiries table i can have many different ticket ID's with same Opportunity ID, but the value will be in only one Ticket ID and same Ticket ID is not neccesarly in F_Escalation table, but the deal value for the same Opportunity ID will appear in another Ticket ID F_SCC_Ticket_and_Inquiries table.

In the example below with Many-to-Many active relationship that is what happens:
I have in F_Escalation table Ticket ID's - 2 and 5. I have same in F_SCC_Ticket_and_Inquiries, but there is no Deal value for them. However I would like to see the Deal value which appears in Ticket ID 1 and 7, because the Opportunity ID in Ticket ID 5 and 1 is the same and in 2 and 7 is again same.