COUNTROWS DAX Function

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

DAX Syntax COUNTROWS(‘table’)

Example: Count the number of rows in the table Sheet1.

DAX

Count the rows = COUNTROWS('Sheet1')
COUNTROWS dax function