Power BI - Power Query Editor
You want to create a measure that counts how many sales have PurchaseAmount over $500 in the Sales table. Which DAX expression correctly filters the Sales table?
COUNTROWS(FILTER(Sales, ____))You want to create a measure that counts how many sales have PurchaseAmount over $500 in the Sales table. Which DAX expression correctly filters the Sales table?
hard📝 Scenario Q15 of 15
Step-by-Step Solution
Solution:
Step 1: Identify the filter condition for purchases over $500
The condition should check if PurchaseAmount is greater than 500 to filter relevant sales.Step 2: Confirm the correct column and operator
Sales[PurchaseAmount] > 500 uses Sales[PurchaseAmount] > 500, which correctly filters sales over $500.Final Answer:
Sales[PurchaseAmount] > 500 -> Option DQuick Check:
Filter sales where PurchaseAmount > 500 = D [OK]
Quick Trick: Filter by purchase amount greater than 500 [OK]
Common Mistakes:
- Filtering by CustomerID instead of PurchaseAmount
- Using less than instead of greater than
- Confusing column names
Master "Power Query Editor" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes