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