cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Customer count vs New Customer count

Hello All,

 

I'm having an issue with the total on my Customer Count and could use some help on why this is happening. The total for Customer Count in 2020 is 944, but when you look at the monthly breakdown those numbers don't add up. My New Customer Count seems to be working just fine. Here is my formula for Customer Count:

 

Customer Count = DISTINCTCOUNT(eBusinessActivity[CustomerId])

 

Pretty simple but for some reason I'm not understanding why my numbers for that column don't add up. Any help would be greatly appreciated.

 

Thanks!

 

customer count.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

@nleuck 

its because your customers could exists in dfferent monthes. so, in month level you see distinct customers count for the month

for total level - distinct count for year and it's not a sum of the month's distinct counts


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

@nleuck 

its because your customers could exists in dfferent monthes. so, in month level you see distinct customers count for the month

for total level - distinct count for year and it's not a sum of the month's distinct counts


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

Highlighted

@az38 

 

Thank you! I was completely over thinking what was actually going on.

Highlighted
Community Support
Community Support

Hi @nleuck 

 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors