How does the COUNTROWS function (DAX) work?

The COUNTROWS function (DAX)counts the number of rows within a Power BI table.

COUNTROWS Formula Syntax

COUNTROWS(
     <table>
)

How do you use the COUNTROWS function?

The COUNTROWS function is used to count the unique values in a column using the current filter context. It can also be used to check whether a column has only one item filtered/selected in the current context.

Related Blog Posts

 

Considerations when using the COUNTROWS function

If a table has no rows, the function returns a blank. If there are rows but none of them has the specified criteria, the function returns 0.

Related Video Tutorials

Formula examples using the COUNTROWS function

=COUNTROWS(‘Orders’)

=COUNTROWS(RELATEDTABLE(ResellerSales))

Related DAX Functions

Related Course Modules