SQL Server Analysis Services 2012 Cube Development Cookbook

Distinct count measure groups

As you learned earlier in this chapter, the DISTINCT COUNT aggregation function supplies the count of unique values within a fact table. Analysis Services handles DISTINCT COUNT measure groups somewhat differently than measure groups that include measures with other aggregation functions.

How to do it...

To implement a distinct count measure, perform the following steps:

1. Right-click on an existing measure group and select New Measure.
2. Change the Usage to Distinct count and choose the column Analysis Services, which should be used for counting distinct values.
3. SSDT will create a separate measure group for the distinct count measure.
4. Give the new measure a descriptive name and set the necessary properties.

There's more... ...