DistinctCount -- Analysis Service
As we all know that DistinctCount is a challenge for SSAS. Since its not an additive measure. AS needs additional efforts to get distinct count. There are number of articles on how to optimize distinct count. In general there we can get distinct count by two ways:
1. Set aggregation usage of Distinctcount type while designing cube.
2. Using DistinctCount MDX Function
There are some alternate ways also available on how to count distinctcount. Lets look at another approach on how to get distinctcount.
Tags: design