Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Marcus Hill, the South manager, wants his small-business (SMB) customers ranked by revenue so he can plan account reviews. The AI assistant's Customer Rank shows 1 on every row.
AI assistant: “Customer Rank is set up with RANKX over the customer names, by Revenue. Every customer shows rank 1, so South's SMB accounts are evenly matched.”
Fix Customer Rank so each customer gets their rank by [Revenue] among the customers in the matrix (SMB, in the sliced region), highest first. Keep the total row blank.
Matrix
Updates as you typeFilters on this visualcustomers[segment] is SMB
Loading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe