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