COUNTROWS in Power BI - Step-by-Step Guide

Introduction

COUNTROWS helps you count how many rows are in a table or a filtered table. It solves the problem of quickly knowing the number of records without manually counting them.

When you want to know how many sales transactions happened in a month.

When you need to count how many customers made purchases in a specific region.

When you want to display the number of products in stock in a report.

When you want to count rows after applying filters like date or category.

When you want to create a card visual showing total orders count.

Steps

Step 1: Open

- Power BI Desktop

Your report and data model are visible on screen

Step 2: Click

- Modeling tab

Modeling options appear in the ribbon

Step 3: Click

- New measure button

A formula bar appears to enter a DAX expression

Step 4: Type

- Formula bar

Measure is ready to calculate row count

💡 Use syntax: MeasureName = COUNTROWS(TableName)

Step 5: Press

- Enter key

Measure is created and appears in Fields pane

Step 6: Drag

- New measure to a card visual on the report canvas

Card shows the number of rows in the specified table

Before vs After

Before

No measure exists to count rows; report shows raw data only

After

A card visual shows '120' representing total rows in Sales table

Settings Reference

TableName

📍 Inside COUNTROWS function in formula bar

Specifies which table's rows to count

Default: None

Filters inside COUNTROWS

📍 Inside COUNTROWS, you can use FILTER function

Counts rows that meet specific conditions

Default: No filter (counts all rows)

Common Mistakes

Using COUNTROWS without specifying a table

COUNTROWS needs a table argument to count rows; missing it causes error

Always write COUNTROWS(TableName) with a valid table name

Trying to count rows of a column instead of a table

COUNTROWS works on tables, not columns; columns alone cause errors

Use COUNTROWS(Table) or use COUNT for counting non-blank values in a column

Summary

COUNTROWS counts how many rows are in a table or filtered table.

You must provide a table name inside COUNTROWS.

It is useful for showing total counts in reports and dashboards.