count-tuple-mdx.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
Count (Tuple) (MDX)	Count (Tuple) (MDX)	kfollis	kfollis	kfollis	02/17/2022	sql	analysis-services	reference	mdx

Count (Tuple) (MDX)

Returns the number of dimensions in a tuple.

Syntax

  
Tuple_Expression.Count  

Arguments

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

Remarks

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]  

See Also

Count (Dimension) (MDX)
Count (Hierarchy Levels) (MDX)
Count (Set) (MDX)
MDX Function Reference (MDX)