[Solved] Given the DAX measure:Measure = IF(ISBLANK(SUM(Sales[Amount])), 0, SUM(Sales[Amount]))What will be the result if all 'Sales[Amount]' values are blank? | Power BI

Power BI - Data Cleaning with Power Query

Given the DAX measure:

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

What will be the result if all 'Sales[Amount]' values are blank?

AThe measure returns 0

BThe measure returns blank

CThe measure returns an error

DThe measure returns the sum of blank values

Step-by-Step Solution

Solution:

Step 1: Evaluate SUM of blank values
SUM of blank values returns blank in DAX.
Step 2: Apply IF condition
ISBLANK(SUM(...)) is TRUE, so measure returns 0 as specified.
Final Answer:
The measure returns 0 -> Option A
Quick Check:
Blank sum replaced by 0 = 0 [OK]

Quick Trick: Use IF(ISBLANK()) to replace blank sums with zero [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

Given the DAX measure: