Bird
0
0

What will the following DAX expression return?

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

What will the following DAX expression return?
FILTER(Employees, Employees[Department] = "HR" && Employees[Salary] >= 60000)

AA table of employees in any department with salary less than 60000
BA table of employees in the HR department with salary greater than or equal to 60000
CA single value showing the count of employees in HR
DAn error due to incorrect syntax
Step-by-Step Solution
Solution:

  1. Step 1: Understand FILTER function

    FILTER returns a table filtered by the given condition.

  2. Step 2: Analyze the condition

    The condition filters rows where Department equals "HR" and Salary is at least 60000.

  3. Final Answer:

    A table of employees in the HR department with salary greater than or equal to 60000 -> Option B

  4. Quick Check:

    Check logical operators and column references [OK]
Quick Trick: FILTER returns filtered table, not aggregated values [OK]
Common Mistakes:
  • Confusing FILTER with aggregation functions
  • Misinterpreting logical AND (&&) conditions
  • Assuming FILTER returns a scalar value

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