Wrong total due to modelling

[AntoineOA]

Hello, I'm working on dashboard where I try get the number of deals per region. The total of active deals is 30 and should be split between Europe, America etc.. But I have 30 for each region.
The count of deals is in the Deal table and the region in the company table. The link between these two tables is made with a third table. The screenshoot will help you to understand the undirect relation. I don't know to fix this and I'm almost sure that the probleme is due to the relation. All the data is from a dump of Hubspot (CRM) into my slq server

Thank you 😄

[Vallirajap · Accepted solution]

Hii @AntoineOA, 

Change the relationship from single to both in each relationship to check whether the total is correct or not.

Go to Model view -> Properties -> cross filter direction.

Did I answer your question?

Mark my post as a solution, this will help others...!

Hit the kudo also,

Thank you.

[AntoineOA]

That was the solution!! Thank you 😄