You wrote a DAX measure to calculate average sales, but the result is incorrect because some sales values are blank or zero. What should you do to fix this?

medium📝 Formula Fix Q14 of 15

Power BI - Data Cleaning with Power Query

AModify the measure to ignore blank and zero values using a filter

BDelete all rows with blank or zero sales from the source file manually

CChange the measure to sum sales instead of average

DRestart Power BI to refresh the data

Step-by-Step Solution

Solution:

Step 1: Identify issue with blanks and zeros in average calculation
Blanks and zeros can skew average results if not excluded properly.
Step 2: Apply filter in DAX measure to exclude blanks and zeros
Using a filter like FILTER or CALCULATE with conditions removes unwanted values from calculation.
Final Answer:
Modify the measure to ignore blank and zero values using a filter -> Option A
Quick Check:
Filter blanks/zeros in measure = Correct average [OK]

Quick Trick: Filter out blanks and zeros in DAX for correct averages [OK]

Common Mistakes:

Deleting data manually instead of filtering
Switching aggregation without fixing data
Thinking restart fixes calculation errors

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More Power BI Quizzes

You wrote a DAX measure to calculate average sales, but the result is incorrect because some sales values are blank or zero. What should you do to fix this?

Step 1: Identify issue with blanks and zeros in average calculation

Step 2: Apply filter in DAX measure to exclude blanks and zeros

Final Answer:

Quick Check:

Want More Practice?