COUNTROWS in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table lists products and their category. All products here belong to the 'Fruit' category.

Cell	Value
A1	Product
A2	Apple
A3	Banana
A4	Cherry
A5	Date
B1	Category
B2	Fruit
B3	Fruit
B4	Fruit
B5	Fruit

Formula Trace

COUNTROWS(FILTER(Table1, Table1[Category] = "Fruit"))

Step 1: FILTER(Table1, Table1[Category] = "Fruit")

Step 2: COUNTROWS(Table with rows [Apple, Banana, Cherry, Date])

Cell Reference Map

   A        B
1 Product  Category
2 Apple    Fruit  <-- included
3 Banana   Fruit  <-- included
4 Cherry   Fruit  <-- included
5 Date     Fruit  <-- included

The formula uses the Category column (B2:B5) to filter rows where the value is 'Fruit'. All rows from 2 to 5 are included.

Result

   A        B        C
1 Product  Category  Result
2 Apple    Fruit     4

The result 4 shows the count of rows where Category is 'Fruit'. It is placed in cell C2.

Sheet Trace Quiz - 3 Questions

What does the FILTER function return in this formula?

A All rows where Category is 'Fruit'

B Only the first row

C Rows where Product is 'Apple'

D No rows

Key Result

COUNTROWS counts the number of rows in a table or filtered table.