Support center for flex.bi version 4.0
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 | 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.
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