Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
HASONEVALUE. HASONEVALUE(Table[Column]) is TRUE when exactly one value of the column is visible in the cell. It guards a calculation that only makes sense for one item: inside IF(HASONEVALUE(…), …), VALUES of the column is a single value you can use as a number or text. On a total row it is FALSE, so the IF returns blank.
Product Price = IF(HASONEVALUE(products[product_name]), VALUES(products[list_price]))
The regional revenue matrix goes to the leadership meeting, and Grace wants the name of the manager to call next to each region. A total row with one manager's name on it would point at the wrong person.
Write the measure Manager Name on regions: the region's manager when the cell shows exactly one region, and blank otherwise (so the total row stays empty).
Matrix
Updates as you typeLoading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe