Goal: Identify missing data.
Note: A "Blank" (Null) is not the same as Zero (0).
Ready...
💻 DAX Formula
-- Scenario 1: Detect Blanks
MEASURE Status = IF( ISBLANK( Inventory[Qty] ), "Missing", "OK" )
-- Scenario 2: Replace Blank with 0
MEASURE Safe_Qty =
IF(
ISBLANK( Inventory[Qty] ),
0, -- Use 0 if blank
Inventory[Qty] -- Else use value
)