[Solved] You have two tables: 'Sales' from SQL Server and 'Targets' from... What will happen if you create a measure: Total Sales = SUM(Sales[Amount]) and use it in a report filtered by 'Targets[Year]'? | Power BI

Power BI - Getting Data

You have two tables: 'Sales' from SQL Server and 'Targets' from Excel. You create a relationship on 'ProductID'. What will happen if you create a measure:
Total Sales = SUM(Sales[Amount]) and use it in a report filtered by 'Targets[Year]'?

AThe measure will respect the filter on Targets[Year] and show filtered sales

BThe measure will ignore the filter on Targets[Year] and show total sales

CThe measure will cause an error due to different data sources

DThe measure will only sum sales for products missing in Targets

Step-by-Step Solution

Solution:

Step 1: Understand relationships across data sources
Power BI relationships work across data sources if modelled correctly, enabling cross-filtering.
Step 2: Analyze measure behavior with filters
The measure sums Sales[Amount] and respects filters from related tables like Targets[Year].
Final Answer:
The measure will respect the filter on Targets[Year] and show filtered sales -> Option A
Quick Check:
Cross-source filter affects measure = True [OK]

Quick Trick: Relationships enable filters across sources [OK]

Common Mistakes:

Assuming filters don't work across sources
Expecting errors due to multiple sources
Thinking measure sums unrelated data

Master "Getting Data" in Power BI

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

More Power BI Quizzes

You have two tables: 'Sales' from SQL Server and 'Targets' from Excel. You create a relationship on 'ProductID'. What will happen if you create a measure:

Step 1: Understand relationships across data sources

Step 2: Analyze measure behavior with filters

Final Answer:

Quick Check:

Want More Practice?