Result in Visualization is not same in Data source

[Raed]

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

All Customer In JP = COUNT(JPCustomer[CustomerNo])

my quastion why there are deffirencts ?

Relation between tablesnumber of customers in data tabnumber of customers in visualization chart

[Raed]

Thank you very much , i fixed the relation and change the relation ,

[Migasuke · Accepted 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.