You want to create a measure that sums 'Sales[Amount]' but treats blank and null values as zero. Which DAX expression achieves this correctly?

hard📝 Scenario Q8 of 15

Power BI - Data Cleaning with Power Query

ASUMX(Sales, COALESCE(Sales[Amount], 0))

BSUM(Sales[Amount]) + 0

CIF(ISBLANK(SUM(Sales[Amount])), 0, SUM(Sales[Amount]))

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

Step-by-Step Solution

Solution:

Step 1: Understand how to treat blanks per row
COALESCE(Sales[Amount], 0) replaces blank/null per row with zero.
Step 2: Use SUMX to iterate and sum replaced values
SUMX iterates rows, summing the replaced values correctly.
Step 3: Evaluate other options
Adding zero to SUM does not replace blanks per row; IF with = BLANK() is invalid syntax.
Final Answer:
SUMX(Sales, COALESCE(Sales[Amount], 0)) correctly sums treating blanks as zero -> Option A
Quick Check:
Use SUMX with COALESCE for row-level blank handling [OK]

Quick Trick: Use SUMX + COALESCE to treat blanks as zero per row [OK]

Common Mistakes:

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More Power BI Quizzes