cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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

@az38 

 

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

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
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors