[Solved] You wrote this DAX measure to replace blanks with zero:Measure = IF(ISBLANK(SUM(Sales[Amount])), 0, SUM(Sales[Amount]))But it always returns zero even when data exists. What is the likely issue? | Power BI

Power BI - Data Cleaning with Power Query

You wrote this DAX measure to replace blanks with zero:

Measure = IF(ISBLANK(SUM(Sales[Amount])), 0, SUM(Sales[Amount]))

But it always returns zero even when data exists. What is the likely issue?

ASUM returns blank only if no rows exist, else returns number.

BISBLANK does not detect blanks in aggregation results correctly.

CSUM(Sales[Amount]) is evaluated twice causing error.

DIF syntax is incorrect; should use SWITCH instead.

Step-by-Step Solution

Solution:

Step 1: Understand SUM and ISBLANK interaction
SUM returns blank only if there are no rows to sum. If rows exist but values are zero, SUM returns zero, not blank.
Step 2: Analyze why measure returns zero always
If SUM returns zero (not blank), ISBLANK returns false, so measure returns SUM. But if data is missing, SUM returns blank and measure returns zero. The issue is likely data or filter context causing SUM to be blank.
Final Answer:
SUM returns blank only if no rows exist, else returns number. -> Option A
Quick Check:
SUM returns blank only if no rows = C [OK]

Quick Trick: SUM returns blank only if no rows, not for zeros [OK]

Common Mistakes:

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

You wrote this DAX measure to replace blanks with zero: