DAX Function Guide

COUNT
Empty image or helper icon

Sam McKay

CEO & Founder

How does the COUNT 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?

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

Loading

Considerations when using the COUNT?

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

Loading

Formula examples using the COUNT

=COUNT([ShipDate])

=COUNT(B5:B11)

=COUNT(1,2,”apple”)

Related Courses

Loading