Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
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]
Count (Dimension) (MDX)
Count (Hierarchy Levels) (MDX)
Count (Set) (MDX)
MDX Function Reference (MDX)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today