The COUNTROWS function is used to counts the number of rows in the specified table, or in a table defined by an expression.
|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 to count the total number of rows in the “Orders” table/dataset.
COUNTROWS = COUNTROWS(Orders) Here, Orders is Dataset name
Step-2: Now, add a card visual to visualize the output of the measure.
Step-3: If you want to see Region wise counts, To achieve this, place a slicer on the report canvas and then drag the “Region” column onto it.
Step-4: You can also use COUTROWS DAX function with FILTER DAX, if you wish to count the rows associated with a specific Region-
COUNTROWS = CALCULATE( COUNTROWS(Orders), FILTER(Orders, Orders[Region]="East"))
It will return number of rows under East region.
- 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.