Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
COUNTROWS. COUNTROWS(table) counts the rows of a table that the current cell can see. Pick the table where one row is one of the things you want to count: one row per customer, per order, per order line.
Product Count = COUNTROWS(products)
Sales is splitting next year's account managers across the regions and wants to start from how many customers each region looks after.
Write the measure Customer Count on customers: the number of customers. The matrix already shows it by region.
Matrix
Updates as you typeLoading the Brightline model…
Language