Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

Count (Tuple) (MDX)

Returns the number of dimensions in a tuple.

Tuple_Expression.Count

Tuple_Expression

A valid Multidimensional Expressions (MDX) expression that returns a tuple.

Returns the number of dimensions in a tuple.

Example

The calculated measure in the following query returns the value 2, which is the number of hierarchies present in the tuple ([Measures].[Internet Sales Amount], [Date].[Calendar].[Calendar Year].&[2001]):

WITH MEMBER MEASURES.COUNTTUPLE AS
COUNT(([Measures].[Internet Sales Amount], [Date].[Calendar].[Calendar Year].&[2001]))
SELECT MEASURES.COUNTTUPLE ON 0
FROM [Adventure Works]
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft