Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 😄
Solved! Go to 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.
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.
That was the solution!! Thank you 😄
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |