Returns the number of tuples in a set.
Empty cells are included unless ExcludeEmpty optional flag is used.
Syntax
Code Block |
---|
Count( Set_Expression [ , ( ExcludeEmpty | IncludeEmpty ) ] )
OR
Set_Expression.Count |
Arguments
Set_Expression | MDX expression that returns set. |
---|
ExcludeEmpty | Empty cells are included unless this optional flag is used. |
---|
Examples
Following example counts for how many new customers are added at the current date.
[Customer].CurrentMember, |
[Measures].[Invoice amount]), |
[Measures].[Invoice amount] > 0 AND |
[Measures].[Invoice amount] = (Sum(PreviousPeriods([Time].CurrentHierarchyMember), [Measures].[Invoice amount])) +[Measures].[Invoice amount] |
See also