Returns the number of tuples in a set.
Empty cells are included unless ExcludeEmpty optional flag is used.
Syntax
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 issues, that are still due, assignee is the same user that is reporter.
Count(Filter( Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]), [Measures].[Issues due] > 0), StrComp([Issue].CurrentMember.get('Assignee name'), [Issue].CurrentMember.get('Reporter name')) = 0 )new customers are added at the current date.
NonZero(Count( Filter( NonEmptyCrossJoin( Descendants(
[Customer].CurrentMember, [Customer].[Customer]
), [Measures].[Invoice amount]), [Measures].[Invoice amount] > 0 AND [Measures].[Invoice amount] = (Sum(PreviousPeriods([Time].CurrentHierarchyMember), [Measures].[Invoice amount])) +[Measures].[Invoice amount] ) ))
See also