Counting functions

DAX counting functions differ in what they count: COUNTROWS the rows of a table, COUNT the non-blank numeric values of a column, COUNTA the non-blank values of any type, DISTINCTCOUNT the distinct values. The choice depends on the question asked and the treatment of blanks.

Example

Commandes = COUNTROWS(Commandes)

Related concepts

The whole glossary