Microsoft Power BI Data Analyst Practice Question

The correct DAX expression is CALCULATE(SUM('Sales'[SalesAmount]), 'Product'[Category] = "Bikes").

The CALCULATE function modifies the filter context in which its expression (the first argument) is evaluated. When a simple boolean expression like 'Product'[Category] = "Bikes" is used as a filter argument, it overwrites any existing filters on the 'Product'[Category] column. This ensures that no matter what category is selected in a slicer, this measure will ignore that selection and apply its own filter context, calculating the sum of SalesAmount exclusively for the 'Bikes' category.

• The expression using FILTER('Product', ...) is incorrect because FILTER by itself respects the existing filter context. If a user filters the report to 'Clothing', the FILTER function would be evaluated on a Product table that no longer contains 'Bikes', resulting in a blank value.
• The expression using KEEPFILTERS is incorrect because its purpose is to preserve the existing filter context and find the intersection with the new filter. This is the opposite of the requirement, as it would only show a value if 'Bikes' was part of the user's selection.
• The expression using ALL('Product'[Category]) is incorrect because it only removes the filter from the Category column but does not apply a new filter for 'Bikes'. This would result in calculating the total sales for all categories.