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))