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 😄
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.
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.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
