count

Returns the number of selected data items excluding null values. Distinct is an alternative expression that is compatible with earlier versions of the product. All is supported in DQM mode only and it avoids the presumption of double counting a data item of a dimension table.

Syntax

count ( [ all | distinct ] expression [ auto ] )
count ( [ all | distinct ] expression for [ all|any ] expression { ,
 expression } )
count ( [ all | distinct ] expression for report )

Example

count ( Sales )

Result

Returns the total number of entries under Sales.