Bird
0
0

You want to create a measure that counts how many sales have an Amount greater than 100 and belong to the East region. Which DAX expression correctly filters the Sales table?

hard📝 Scenario Q8 of 15
Power BI - Power Query Editor

You want to create a measure that counts how many sales have an Amount greater than 100 and belong to the East region. Which DAX expression correctly filters the Sales table?

ACOUNTROWS(FILTER(Sales, Sales[Amount] > 100 || Sales[Region] = "East"))
BCOUNTROWS(FILTER(Sales, Sales[Amount] > 100 && Sales[Region] = East))
CCOUNTROWS(FILTER(Sales, Sales[Amount] < 100 && Sales[Region] = "East"))
DCOUNTROWS(FILTER(Sales, Sales[Amount] > 100 && Sales[Region] = "East"))
Step-by-Step Solution
Solution:

  1. Step 1: Understand filtering conditions

    We want sales with Amount > 100 AND Region = "East".

  2. Step 2: Check logical operators and text quotes

    COUNTROWS(FILTER(Sales, Sales[Amount] > 100 && Sales[Region] = "East")) uses && (AND) and quotes "East" correctly.

  3. Step 3: Verify COUNTROWS usage

    COUNTROWS counts rows returned by FILTER, which is correct.

  4. Final Answer:

    COUNTROWS(FILTER(Sales, Sales[Amount] > 100 && Sales[Region] = "East")) -> Option D

  5. Quick Check:

    Use && for AND and quote text values [OK]
Quick Trick: Use COUNTROWS with FILTER and && for multiple conditions [OK]
Common Mistakes:
  • Using || instead of && for AND
  • Forgetting quotes around text
  • Using less than instead of greater than

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes
Basic Visualizations - Pie and donut charts - Quiz 6medium Data Cleaning with Power Query - Pivoting columns - Quiz 5medium Data Cleaning with Power Query - Header promotion - Quiz 3easy Formatting and Design - Report backgrounds and images - Quiz 14medium Formatting and Design - Color themes - Quiz 13medium Getting Data - OData and REST API connections - Quiz 13medium Getting Data - Web data import - Quiz 10hard Getting Data - Multiple data sources in one report - Quiz 2easy Power BI Basics and Architecture - Power BI workflow (get data, transform, visualize, share) - Quiz 2easy Power Query Editor - Applied steps and undo - Quiz 11easy