COUNTROWS in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to count the number of rows in the 'Sales' table.

Power BI

TotalRows = [1](Sales)

Drag options to blanks, or click blank then click option'

ACOUNTROWS

BSUM

CAVERAGE

DMAX

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM or AVERAGE instead of COUNTROWS.

Trying to count rows with MAX function.

The COUNTROWS function counts the number of rows in a table. Here, it counts rows in the 'Sales' table.

2fill in blank

medium

Complete the code to count rows in the 'Customers' table where the 'Country' column equals 'USA'.

Power BI

USA_Customers = COUNTROWS(FILTER(Customers, Customers[Country] = [1]))

Drag options to blanks, or click blank then click option'

ACanada

BUSA

C"USA"

D'USA'

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around text values.

Using single quotes instead of double quotes.

Text values in DAX must be enclosed in double quotes. So, "USA" is correct to filter the 'Country' column.

3fill in blank

hard

Fix the error in the code to count rows in 'Orders' where 'Status' is 'Completed'.

Power BI

CompletedOrders = COUNTROWS(FILTER(Orders, Orders[Status] = [1]))

Drag options to blanks, or click blank then click option'

ACompleted

BCompleted"

C'Completed'

D"Completed"

Attempts:

3 left

💡 Hint

Common Mistakes

Using text without quotes.

Using single quotes instead of double quotes.

Mismatched or incomplete quotes.

The text value 'Completed' must be enclosed in double quotes in DAX. So, "Completed" is correct.

4fill in blank

hard

Fill both blanks to count rows in 'Products' where 'Category' is 'Bikes' and 'Price' is greater than 1000.

Power BI

ExpensiveBikes = COUNTROWS(FILTER(Products, Products[Category] = [1] && Products[Price] [2] 1000))

Drag options to blanks, or click blank then click option'

A"Bikes"

B"Cars"

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using single quotes for text.

Using wrong comparison operator for price.

Forgetting to use double ampersand && for AND.

Use "Bikes" with double quotes for text and the greater than symbol > to filter prices above 1000.

5fill in blank

hard

Fill all three blanks to count rows in 'Employees' where 'Department' is 'Sales', 'Age' is greater than 30, and 'Active' is TRUE.

Power BI

ActiveSalesOver30 = COUNTROWS(FILTER(Employees, Employees[Department] = [1] && Employees[Age] [2] 30 && Employees[Active] = [3]))

Drag options to blanks, or click blank then click option'

A"Sales"

B>

CTRUE()

DFALSE()

Attempts:

3 left

💡 Hint

Common Mistakes

Using FALSE() instead of TRUE().

Not quoting the text value.

Using && incorrectly.

Use "Sales" for the department text, > for age comparison, and TRUE() for the boolean active status.