DistinctCount (MDX)

Returns the number of distinct, nonempty tuples in a set.

Syntax

DistinctCount(Set_Expression)

Arguments

• Set_Expression
  A valid Multidimensional Expressions (MDX) expression that returns a set.

Remarks

The DistinctCount function is equivalent to Count(Distinct(Set_Expression), EXCLUDEEMPTY). This function can be applied only on calculated measures, and it can involve only the topmost level.

See Also

Reference

Count (Set) (MDX)
MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
17 July 2006	Changed content: Updated syntax and arguments to improve clarity.