Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Counting per row. Inside an iterator over customers, COUNTROWS(orders) still sees every order in the current filters, because a row context doesn't filter other tables. RELATEDTABLE(orders), or a measure such as [Orders], turns the current customer into a filter first. AVERAGEX skips customers whose count is blank.
Avg Lines per Order = AVERAGEX(orders, COUNTROWS(RELATEDTABLE(order_items)))
Account managers want to know how often a typical customer orders. The AI assistant built Avg Orders per Customer, and it claims the average customer in South placed almost 300 orders this year.
AI assistant: “Avg Orders per Customer is ready: customers in South average 294 completed orders each, so South has the most loyal customers.”
Fix Avg Orders per Customer: for each customer with completed orders, count their completed orders, then average those counts by region.
Matrix
Updates as you typeFilters on this visualorders[status] is completed
Loading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe