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')