DAX function

BLANK — DAX function reference

Return an explicit blank.

Syntax

dax

BLANK()

dax

IF([Sales] = 0, BLANK(), [Sales])

→ A blank

dax

IF(SUM(Sales[Quantity]) = 0, BLANK(), SUM(Sales[Amount]) / SUM(Sales[Quantity]))

→ Blank instead of a misleading zero when there is no quantity

dax

SWITCH(TRUE(), [Total Sales] = 0, BLANK(), [Total Sales] < 0, "Negative", "Positive")

→ Suppresses a row entirely rather than showing a 0/false-looking value

Returning BLANK() hides a row or value in most visuals.
Returning BLANK() from a measure hides that row/column in most Power BI visuals by default — desirable for suppressing "no data" rows, but it also means a genuinely-zero result and a blank result can look identical unless "Show items with no data" is checked.
BLANK() has specific propagation rules that don’t always match intuition (e.g., BLANK() = 0 evaluates TRUE in a comparison, but ISBLANK(0) is FALSE) — test edge cases rather than assuming SQL NULL semantics.

From Logical & error handling