Table of contents
TOC
Collapse the table of content
Expand the table of content

COUNTROWS Function (DAX)

Owen Duncan|Last Updated: 5/22/2018

The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.

Syntax

COUNTROWS(<table>)  

Parameters

TermDefinition
tableThe name of the table that contains the rows to be counted, or an expression that returns a table.

Return Value

A whole number.

Remarks

This function can be used to count the number of rows in a base table, but more often is used to count the number of rows that result from filtering a table, or applying context to a table.

Whenever there are no rows to aggregate, the function returns a blank. However, if there are rows, but none of them meet the specified criteria, the function returns 0. Microsoft Excel also returns a zero if no rows are found that meet the conditions.

Example

The following example shows how to count the number of rows in the table Orders. The expected result is 52761.

=COUNTROWS('Orders')  

Example

The following example demonstrates how to use COUNTROWS with a row context. In this scenario, there are two sets of data that are related by order number. The table Reseller contains one row for each reseller; the table ResellerSales contains multiple rows for each order, each row containing one order for a particular reseller. The tables are connected by a relationship on the column, ResellerKey.

The formula gets the value of ResellerKey and then counts the number of rows in the related table that have the same reseller ID. The result is output in the column, CalculatedColumn1.

=COUNTROWS(RELATEDTABLE(ResellerSales))  

The following table shows a portion of the expected results:

ResellerKeyCalculatedColumn1
173
270
3394

See Also

COUNT Function (DAX)
COUNTA Function (DAX)
COUNTAX Function (DAX)
COUNTX Function (DAX)
Statistical Functions (DAX)

© 2018 Microsoft