Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
BLANK and COALESCE. DAX returns blank, not 0, when there is nothing to add up, and a matrix hides a row when every measure on it is blank. COALESCE(a, b) returns a unless a is blank, and then b. COALESCE(x, 0) turns a blank into a zero, but only do it where a zero means something: a zero is never hidden, so it can fill a matrix with empty rows.
Units or Zero = COALESCE([Units], 0)
Elena Petrova reviews North month by month. In months with no refunds the Refunded column is empty, and she keeps asking whether the data is missing. She wants a 0 there instead.
Write the measure Refunded on refunds: the sum of refunds[amount], but 0 instead of blank when a month has no refunds. The matrix shows 2025 by month, next to [Orders], with the region slicer on North.
Matrix
Updates as you typeFilters on this visual'Date'[Year] is 2025
Loading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe