Page Comparison

Returns the number of tuples in a set.

Empty cells are included unless ExcludeEmpty optional flag is used.

Syntax

Code Block
Count( Set_Expression [ , ( ExcludeEmpty \| IncludeEmpty ) ] ) OR Set_Expression.Count

Set_Expression	MDX expression that returns set.
ExcludeEmpty	Empty cells are included unless this optional flag is used.

Following example counts for how many new customers are added at the current date.

Code Block
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]

)