Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Measures and SUM. A measure is a calculation Power BI works out for every cell of a visual, using that cell's filters: in the North row it only sees North's rows. SUM(table[column]) adds up a column.
Stock Value = SUM(products[unit_cost])
The operations lead is planning warehouse stock and wants to know how many units each region sold in completed orders.
Write the measure Units Sold on order_items: the total number of units sold. The matrix already shows it by region, filtered to completed orders.
Matrix
Updates as you typeFilters on this visualorders[status] is completed
Loading the Brightline model…
Language