I tried to build one report to show the number of customers in Journy Plan for each sales man , but when i tried to make Count Function the result in visulisation chart appeared 135 customers and when go to data tab and make filter by sales man it's appeard 153
knowing i use the
my quastion why there are deffirencts ?
Relation between tables
number of customers in data tab
number of customers in visualization chart
Solved! Go to Solution.
Hi @Raed ,
I do not see in your model JPCustomer[CustomerNo] but I have an idea where the problem is.
You use some many:many bi-directional relationships. This kinda relationship causes problems in many cases.
Maybe try to remove the relationships and then do the count for JPCustomer[CustomerNo]. If the number is OK, then add the relationships back and watch if the number is changed.
Thank you very much , i fixed the relation and change the relation ,
Hi @Raed ,
I do not see in your model JPCustomer[CustomerNo] but I have an idea where the problem is.
You use some many:many bi-directional relationships. This kinda relationship causes problems in many cases.
Maybe try to remove the relationships and then do the count for JPCustomer[CustomerNo]. If the number is OK, then add the relationships back and watch if the number is changed.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
78 | |
68 | |
56 | |
56 |
User | Count |
---|---|
200 | |
104 | |
85 | |
80 | |
77 |