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 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