Distinct count is wrong

Hello, Shane!

Thank you for reaching out to us.

Please note that the grand total distinct count is calculated as the distinct count of the "Account" field's members in the entire dataset. This aggregation's grand total does not show the sum of distinct counts for different members. If two rows with different names in the "Method" have the same "Account" member, this will result in adding 1 to the grand total distinct count.

For a better understanding, we have prepared a simplified example: https://jsfiddle.net/flexmonster/mg35rf1d/ 
Here, the "Accessory" category is associated with two colors ("green" and "red"), so the total distinct count is 2. The "Cars" category is only associated with "red" - the total distinct count is 1. But, since the "green" and "red" colors are the only unique colors in the dataset, the grand total distinct count will also equal 2.

Please let us know if our answer helped you.

Best Regards,
Maksym

Hello, Shane!

Hope you are doing well.
We are wondering if we were able to clarify the "Distinct Count" aggregation behavior. 
Please let us know if more questions arise.

Best Regards,
Maksym