OLAP Server User Guide
MDX Documentation
MDX Functions Reference

Count

(MDX)

Returns the number of elements in the specified set.

Parameters

Name Type Cardinality Default value
  set-expression  one   
  EXCLUDEEMPTY|INCLUDEEMPTY  zero-one  INCLUDEEMPTY 

Return

numeric-value

Description

Returns the number of elements in the specified set.

INCLUDEEMPTY (default behavior) : empty cells are included in the count (using the measure in the current context).

EXCLUDEEMPTY : does not includes empty cells in the count (using the measure in the current context).

set-expression.Count : an alternate syntax that is equivalent to Count( set-expression, INCLUDEEMPTY )

See Also

DistinctCount Count(Dimensions) Count(Levels) Count(Level)

Examples

Special Examples (errors, null, ...)

XMLA Properties

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