🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate28 / 150
Question 28 of 150

An analyst builds a measure to count high-value orders (amount greater than 1000). When they place this measure in a matrix sliced by product category and also apply an external filter selecting only the 'Electronics' category, they notice that a standard CALCULATE with a boolean filter on order amount unexpectedly overrides part of the existing category filter behavior in a comparison measure. They want the amount condition applied as an ADDITIONAL constraint that intersects with — rather than replaces — any filters already coming from the same column context. Which DAX function should wrap the filter argument to preserve the existing filter context and intersect the new condition?

Reviewed for accuracy · Report an issueNext question