Table of contents
TOC
Collapse the table of content
Expand the table of content

COUNT Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

The COUNT function counts the number of cells in a column that contain numbers.

Syntax

COUNT(<column>)  

Parameters

TermDefinition
columnThe column that contains the numbers to be counted

Return Value

A whole number.

Remarks

The only argument allowed to this function is a column. The COUNT function counts rows that contain the following kinds of values:

  • Numbers

  • Dates

  • Strings

If the row contains text that cannot be translated into a number, the row is not counted.

When the function finds no rows to count, it returns a blank. When there are rows, but none of them meet the specified criteria, then the function returns 0.

Example

The following example shows how to count the number of numeric values in the column, ShipDate.

=COUNT([ShipDate])  

To count logical values or text, use the COUNTA or COUNTAX functions.

See Also

COUNT Function (DAX)
COUNTA Function (DAX)
COUNTAX Function (DAX)
COUNTX Function (DAX)
Statistical Functions (DAX)

© 2018 Microsoft