I want to calculate a distinct count of customers in a cube of analysis services.
I have a field=CustomerKey in the fact table.
1. I put AggregationFunction=DistinctCount for CustomerKey, but I have this measure in the same measure group with the other measures of the same fact table.Is it a way to move the distinct count in a separate measure group after I had created it?
2 I would like to use an MDX query.What's the easiest way to do this?
ex: count(distinct(set), excludeempty)......What I have to put in the set.....?!?
What't the best way for the performance?
Thank you everybody.