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 |
|