TopCount (MDX)

Returns the highest specified count of tuples. The numeric expression is used to evaluate the tuple values.


Name Type Cardinality Default value
set  set-expression  one   
count  numeric-expression  one 
measure  value-expression  zero-one   




Returns the highest specified count of tuples.

1) A measures expression is specified.

The tuples of the specified set are sorted in descending order according to their cell values. Then, the specified number of tuples with the highest values are returned. Note that empty cells are not ignored and are considered as zero values.

2) A measures expression is not specified.

The TopCount(set,count,measure) function is then equivalent to the Head(Order(set,measure,BDESC),count) function.

See Also

BottomCount TopPercent TopSum Head DrilldownMemberTop


Special Examples (errors, null, ...)

XMLA Properties

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