Microsoft Power BI Data Analyst Practice Question

The CALCULATE function evaluates an expression in a modified filter context. The predicate Product[Category] = "Bikes" adds a filter that keeps only rows where Category is Bikes. The REMOVEFILTERS modifier then clears any existing filters on Product[Subcategory] and Product[Color], so slicers or visual filters on those two columns do not affect the result. Filters from related tables-and from other Product columns-are left intact, so the measure returns Bike sales in the current report context.

A formula that uses ALL(Product) is not appropriate here. ALL(Product) removes filters from every column in the Product table. Although the subsequent predicate re-applies the Bikes category filter, all other Product-level filters (such as Size or Brand) would also be removed, which is broader than the stated requirement.

The SUMX/FILTER expression operates entirely within the existing filter context, so it would still honor Subcategory and Color filters and therefore fails the requirement.

KEEPFILTERS preserves the current filters and intersects them with the Bikes filter, so Subcategory and Color would remain applied. This likewise does not satisfy the need to ignore those two columns.