Document toolboxDocument toolbox

Support center for flex.bi version 3.2

Count

Owned by Gvido
Sept 01, 2016

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