Answer-first summary for fast verification
Answer: FILTER
The FILTER function is the most appropriate choice for this scenario because it allows you to apply a specific condition to filter a table, which is exactly what is needed to include only sales records that meet the criteria of sales amount exceeding $10,000 and product category being 'Electronics'. While CALCULATE can also modify filter context, it is more commonly used for calculating measures with filters rather than directly filtering tables. LOOKUPVALUE is used for retrieving a single value from a table based on criteria, not for filtering tables. EVALUATE is used in DAX queries to return a table but is not a function used within measures or calculated columns for filtering purposes.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are designing a Power BI report that requires complex data analysis involving DAX variables and functions. The analysis includes iterators, table filtering, windowing, and information functions. Specifically, you need to filter a sales data table to only include records where the sales amount exceeds $10,000 and the product category is 'Electronics'. Considering performance and accuracy, which of the following DAX functions is the most appropriate to use for this scenario? Choose one option.
A
CALCULATE
B
LOOKUPVALUE
C
EVALUATE
D
FILTER
No comments yet.