How do you create distinct count measure in the separate measure group from the same fact table
Q: How do you create distinct count measure in the separate measure group from the same fact table?
A: It is recommended to have measure with aggregation type "Distinct count" in the separate measure group. But in the cube designer if fact table already has measure group associated with it, by default new measures based on that fact table with be added to the same measure group. To create new measure group you should use "New Measure..." wizard (button on the toolbar). In this wizard if you select usage "Distinct count", new measure will be added to its own measure group.
Thanks Jeje for this tip.