[Solved] This DAX measure returns unexpected results:Total Sales = SUM(Sales[Amount]) + SUM(Sales[Tax])What could be a reason? | Power BI

Power BI - Basics and Architecture

This DAX measure returns unexpected results:

Total Sales = SUM(Sales[Amount]) + SUM(Sales[Tax])

What could be a reason?

ASUM cannot be used on numeric columns

BAdding two sums may double count if filters overlap

CThe syntax requires commas instead of plus signs

DMeasures cannot use multiple SUM functions

Step-by-Step Solution

Solution:

Step 1: Analyze the measure logic
Adding sums of Amount and Tax is valid but may cause double counting if filters overlap or data is related.
Step 2: Evaluate other options
SUM works on numeric columns, plus sign is correct, and multiple SUMs are allowed.
Final Answer:
Adding two sums may double count if filters overlap -> Option B
Quick Check:
Sum addition caution = Watch for double counting [OK]

Quick Trick: Check filter context when adding sums [OK]

Common Mistakes:

Master "Basics and Architecture" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

This DAX measure returns unexpected results: