fbpx

DistinctCount (MDX)

Returns the number of unique non empty elements in the specified set.

Parameters

Name Type Cardinality Default value
  set-expression  one   

Return

numeric-value

Description

Returns the number of unique elements in the specified set that are no empty.

It is equivalent to Count( Distinct(set), EXCLUDEEMPTY)

See Also

Count NonEmpty

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.