Count

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

ExcludeEmpty

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