This documentation is archived and is not being maintained.

DistinctCount (MDX)

Updated: 17 July 2006

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



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

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.

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.