You have sales data from SQL Server and marketing data from a CSV file. You want to create a measure that calculates sales only for customers who responded to marketing. Which DAX approach is best?

hard📝 Scenario Q9 of 15

Power BI - Getting Data

ACreate a calculated column in sales table checking marketing response

BUse SUMX over the marketing table ignoring sales data

CJoin the tables in Power Query and then sum sales

DUse CALCULATE with FILTER to include only customers present in marketing table

Step-by-Step Solution

Solution:

Step 1: Understand filtering sales by marketing customers
You want to filter sales to customers who responded in marketing data.
Step 2: Use CALCULATE with FILTER for dynamic filtering
CALCULATE with FILTER on customers in marketing table is the best DAX approach.
Final Answer:
Use CALCULATE with FILTER to include only customers present in marketing table -> Option D
Quick Check:
Filter sales by marketing customers using CALCULATE [OK]

Quick Trick: Use CALCULATE with FILTER for cross-table conditions [OK]

Common Mistakes:

Using SUMX only on marketing table
Creating calculated columns instead of measures
Trying to join tables only in Power Query

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

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More Power BI Quizzes

You have sales data from SQL Server and marketing data from a CSV file. You want to create a measure that calculates sales only for customers who responded to marketing. Which DAX approach is best?

Step 1: Understand filtering sales by marketing customers

Step 2: Use CALCULATE with FILTER for dynamic filtering

Final Answer:

Quick Check:

Want More Practice?