Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
DISTINCTCOUNT. DISTINCTCOUNT(table[column]) counts the different values in a column, so repeats count once. Key columns such as order_items[order_id] are hidden from the fields list, but you can still type them in a formula.
Orders With Lines = DISTINCTCOUNT(order_items[order_id])
Marketing wants to know how many different customers bought through each channel, to see how wide each channel's reach is.
Write the measure Active Customers on orders: the number of different customers with an order. The matrix shows it by channel, filtered to completed orders. Count from orders, which holds each order's customer ID.
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