Customer count vs New Customer count

[nleuck]

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!

[v-diye-msft]

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!

[az38 · Accepted solution]

@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

[nleuck]

@az38 

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