Bird
0
0

Given the table Products with columns Category and Price, what will this DAX expression return?

medium📝 dax lod result Q13 of 15
Power BI - Power Query Editor

Given the table Products with columns Category and Price, what will this DAX expression return?

FILTER(Products, Products[Category] = "Beverages" && Products[Price] < 20)
AAll products with Category 'Beverages' and Price less than 20.
BAll products with Category 'Beverages' or Price less than 20.
CAll products with Price less than 20 only.
DAll products with Category 'Beverages' only.
Step-by-Step Solution
Solution:

  1. Step 1: Analyze the FILTER condition

    The condition uses && which means AND, so both must be true: Category = "Beverages" AND Price < 20.

  2. Step 2: Understand the result of FILTER

    FILTER returns rows where both conditions hold, so only products matching both are included.

  3. Final Answer:

    All products with Category 'Beverages' and Price less than 20. -> Option A

  4. Quick Check:

    AND condition filters both criteria = B [OK]
Quick Trick: && means both conditions must be true [OK]
Common Mistakes:
  • Confusing && (AND) with || (OR)
  • Ignoring one condition
  • Assuming it filters only by one column

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