Skip to main content
Version: I2024.1.3

Count (Set)

Returns the non-distinct Count of non-empty dimension members referenced by the dimensional set expression.

Syntax

Count(Dimensional_Member_Set_Expression)

Input Parameters

Dimensional_Member_Set_Expression
A dynamic multidimensional (MDX) member expression. A "dynamic" MDX expression is one that uses the CurrentMember function. Static MDX set expressions are not supported. Dynamic expressions defining sets of tuples using Measures are not supported.

Return Value

Long value representing the non-distinct Count of non-empty dimension members referenced by the expression.

Examples

Count the [DateCustom].[StandardMonth]'s CurrentMember's siblings:

Count([DateCustom].[StandardMonth].CurrentMember.Siblings)

Count the StandardMonth's Year-to-Date members up to the CurrentMember:

Count(YTD([DateCustom].[StandardMonth].CurrentMember))