COUNT Function (DAX)

How does the COUNT function (DAX) work?

The COUNT function (DAX) counts the number of cells in a column that contain non-blank values.

COUNT Formula Syntax

COUNT(
     <column>
)

How do you use the COUNT function?

Used the COUNT function to get the number of entries in a number field that is in a range or array of numbers.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the COUNT function

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

When the function finds no rows to count, it returns a blank.

Blank values are skipped. TRUE/FALSE values are not supported.

If you want to evaluate a column of TRUE/FALSE values, use the COUNTA function.

Related Video Tutorials

Formula examples using the COUNT function

=COUNT([ShipDate])

=COUNT(B5:B11)

=COUNT(1,2,”apple”)

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide