COUNTROWS in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the COUNTROWS function do in Power BI?

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

intermediate

How do you use COUNTROWS with a filter in Power BI?

You use COUNTROWS with the FILTER function to count rows that meet specific conditions, like COUNTROWS(FILTER(Table, Condition)).

beginner

True or False: COUNTROWS can count rows in a physical table only.

False. COUNTROWS can count rows in any table expression, including filtered or calculated tables.

beginner

Write a simple DAX formula using COUNTROWS to count all rows in a table named 'Sales'.

COUNTROWS(Sales)

intermediate

Why is COUNTROWS useful in creating dynamic measures in Power BI?

Because it can count rows based on filters or conditions, helping to create measures that update automatically with user selections.

What does COUNTROWS return when used on a table?

A The number of columns in the table

B The number of rows in the table

C The sum of all numeric values in the table

D The average of all values in the table

COUNTROWS returns the number of rows in the specified table or table expression.

Which DAX expression counts rows where SalesAmount is greater than 100?

A COUNTROWS(FILTER(Sales, Sales[SalesAmount] > 100))

B COUNTROWS(Sales[SalesAmount] > 100)

C COUNTROWS(SalesAmount > 100)

D COUNTROWS(Sales, SalesAmount > 100)

You must use FILTER to create a table of rows meeting the condition, then COUNTROWS counts those rows.

Can COUNTROWS be used on a calculated table expression?

A Yes

B No

C Only if the table is physical

D Only with numeric columns

COUNTROWS works on any table expression, including calculated or filtered tables.

What will COUNTROWS return if the table is empty?

A Error

B 1

C 0

D Null

COUNTROWS returns 0 when the table has no rows.

Which scenario is a good use case for COUNTROWS?

A Counting total sales amount

B Calculating average price

C Finding maximum sales date

D Counting how many customers made purchases

COUNTROWS is useful to count how many rows meet a condition, like customers who made purchases.

Explain how COUNTROWS can be combined with FILTER to count specific rows in a table.

Think about filtering first, then counting.

Describe a real-life example where COUNTROWS would help in a sales report dashboard.

Imagine you want to know how many orders were made last month.