Optimizing your distinct count calculation in Analysis Services Introduction A distinct count (e.g. unique user or visitor counts) provides valuable information but it is not an easy problem to resolve.  An example of this problem is your grocery "market basket" scenario where a single visitor purchased various dairy, meat, and vegetable items.  While there may be eight (for example) items purchased, these items were all purchased by one person.  Understanding that one person purchased many items can be very revealing in the context of business intelligence.  Using a web analytics example, if you have a high activity / visitor web…