COUNTROWS DAX Function (Aggregation)

Counts the number of rows in a table.

Syntax

COUNTROWS ( <Table> )

Parameter	Attributes	Description
Table		The table containing the rows to be counted.

Return values

Scalar A single integer value.

Number of rows obtained by the evaluation of the table expression. If the table has no rows, it returns blank.

Remarks

This function can be used to count the rows of a table expression.

Examples

The following are valid syntaxes.

COUNTROWS ( table )
COUNTROWS ( DISTINCT ( table ) )
COUNTROWS ( VALUES ( table ) )

The COUNTROWS function can be used to count the unique values available in a column for the current filter context. However, DISTINCTCOUNT is better in that case. The following expressions are equivalent.

COUNTROWS ( DISTINCT ( table[column] ) )
DISTINCTCOUNT ( table[column] ) )

The COUNTROWS function can be used to check whether a column has only one item filtered/selected in the current filter context. However, HASONEVALUE is better in that case. The following expressions are equivalent.

COUNTROWS ( VALUES ( table[column] ) ) = 1
HASONEVALUE ( table[column] ) )

Learn more about COUNTROWS in the following articles:

Handling BLANK in DAX

» Read more

Related functions

Other related functions are:

Last update: Oct 20, 2018 » Contribute » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/countrows-function-dax