The COUNTROWS function is used to counts the number of rows in the specified table, or in a table defined by an expression. This function comes under Statistical Functions DAX category.
Refer similar DAX : DISTINCTCOUNT , COUNTBLANK , COUNT, COUNTA & COUNTX
Syntax:
COUNTROWS(<table>)
Description:
| S no. | Parameter | Description |
| 1 | table | The name of the table that contains the rows to be counted, or an expression that returns a table. |
Let’s understand with an example:
Download sample Dataset – SuperStoreUS-2015.xlxs and import into Power BI desktop.
Step-1: Create a measure for counts total no of rows in Orders Table/ Dataset.
COUNTROWS =
COUNTROWS(Orders)
Here Orders is Dataset name
Step-2: Now take one card visual to see the output of measure
CoutRows DAX
Step-3: If you want to see Region wise counts, so for this take on slicer and Drag region column over it.
Countrows DAX Output
Step-4: You can also use COUTROWS DAX function with FILTER DAX, suppose you want to count particular Region rows
COUNTROWS = CALCULATE( COUNTROWS(Orders), FILTER(Orders, Orders[Region]="East"))
It will return number of rows under East region.
Note:
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.
Refer similar DAX : DISTINCTCOUNT , COUNTBLANK , COUNT, COUNTA & COUNTX
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.