Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
AVERAGE. AVERAGE(table[column]) is the mean of a column over the rows the cell can see: their sum divided by how many there are. Blank values are skipped. Use it for rates and percentages, which make no sense added up.
Avg Unit Cost = AVERAGE(products[unit_cost])
The sales director thinks sales reps hand out bigger discounts than the website does and wants the typical discount per order line in each channel.
Write the measure Avg Discount on order_items: the average discount_pct of order lines. The matrix shows it by channel, filtered to completed orders.
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