Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

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


  • No labels