cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Raed
New Member

Result in Visualization is not same in Data source

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 tablesRelation between tablesnumber of customers in data tabnumber of customers in data tabnumber of customers in visualization chartnumber of customers in visualization chart

1 ACCEPTED SOLUTION
Migasuke
Solution Sage
Solution Sage

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.





If my answer was helpful please give me a Kudos or even accept as a Solution.

Let's connect on LinkedIn!

View solution in original post

2 REPLIES 2
Raed
New Member

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

Migasuke
Solution Sage
Solution Sage

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.





If my answer was helpful please give me a Kudos or even accept as a Solution.

Let's connect on LinkedIn!

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors