Count

Returns the number of tuples in a set (the cardinality of the set). This function counts all tuples of the set regardless of empty values. If you wish to count only tuples that evaluate to nonempty values, use NonEmptyCount.

Syntax

Count ( set [, IncludeEmpty] )

Notes

This function returns a zero if the input set is empty.

Example

WITH MEMBER 
 [Measures].[Prod Count] 
AS 
 'Count ( 
    Crossjoin ( 
     {[Measures].[Sales]}, 
     {[Product].children} 
    ) 
  )' 
SELECT 
 { [Scenario].[Actual], [Scenario].[Budget] } 
ON COLUMNS, 
 { 
  Crossjoin ( 
     {[Measures].[Sales]}, 
     {[Product].children} 
    ), 
   ([Measures].[Prod Count], [Product])
 } 
ON ROWS 
FROM 
 Sample.Basic 
WHERE 
 ([Year].[Jan], [Market].[New York])

returns the grid:

The WITH section of the query calculates the count of all products for which a data value exists. The SELECT section arranges the members shown on columns and rows. The entire query is sliced by January and New York in the WHERE section; though those members are not shown in the grid, the data is applicable to those members.