[Solved] A Matrix visual shows incorrect totals that do not match the sum of rows. What could cause this? — Ans: The measure uses a calculation that ignores filters | Power BI

Power BI - Basic Visualizations

A Matrix visual shows incorrect totals that do not match the sum of rows. What could cause this?

AThe data source is missing columns

BThe measure uses a calculation that ignores filters

CThe visual is set to Table instead of Matrix

DThe Rows field is numeric instead of text

Step-by-Step Solution

Solution:

Step 1: Understand measure behavior
Measures ignoring filters can cause totals to differ from row sums.
Step 2: Check visual and data types
Table vs Matrix or field types don't affect total calculation logic.
Final Answer:
The measure uses a calculation that ignores filters -> Option B
Quick Check:
Filter-ignoring measures cause wrong totals [OK]

Quick Trick: Totals differ if measure ignores filters [OK]

Common Mistakes:

Master "Basic Visualizations" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

A Matrix visual shows incorrect totals that do not match the sum of rows. What could cause this?