Bird
0
0

Identify the error in this DAX expression that filters Orders for Quantity greater than 10:

medium📝 Formula Fix Q14 of 15
Power BI - Power Query Editor

Identify the error in this DAX expression that filters Orders for Quantity greater than 10:

FILTER(Orders, Quantity > 10)
AThe table name Orders is missing.
BFILTER cannot be used with numeric conditions.
CQuantity should be referenced as Orders[Quantity].
DThe condition should use < instead of >.
Step-by-Step Solution
Solution:

  1. Step 1: Check column reference in condition

    In DAX, columns must be referenced with table name, so 'Quantity' alone is invalid; it should be 'Orders[Quantity]'.

  2. Step 2: Confirm other parts are correct

    The table 'Orders' is present, and the condition operator > 10 is valid.

  3. Final Answer:

    Quantity should be referenced as Orders[Quantity]. -> Option C

  4. Quick Check:

    Column needs table prefix = C [OK]
Quick Trick: Always prefix columns with table name in FILTER [OK]
Common Mistakes:
  • Using column name without table prefix
  • Thinking FILTER can't use numeric conditions
  • Changing operators without reason

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