COUNT Function (DAX)

How does the COUNT function (DAX) work?

The COUNT function counts the number of cells in a column with a non-blank value.

COUNT Formula Syntax

COUNT(
     <column>
)

How do you use the COUNT function?

The COUNT function is used to count up all the rows in a given column but it will not count blank or empty rows.

Related Blog Posts

 

Considerations when using the COUNT function

This function has only one argument, which is a column. The rows contain any of the following values: numbers, dates, or strings.If it has no rows to count, this function returns a blank. Blank values are skipped, while TRUE/FALSE values are not supported.

Related Video Tutorials

ACOSH Function (DAX)

Formula examples using the COUNT function

=COUNT([ShipDate])

=COUNT(B5:B11)

=COUNT(1,2,”apple”)

Related DAX Functions

COUNTA Function (DAX)
COUNTAX
COUNTX

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI