Filters

Hi jostnachs ,

For your measure %lost, I see that you say you've restricted status=lost in DAX, so in that case, whether status is filtered in a slicer, visual object level filter, or page level filter, it won't affect the value of that measure. Please see the test results below:

Lost est_comm = 
CALCULATE(
    SUM('Table'[est_comm]),
    'Table'[status] = "lost"
)

Without slicer or filter:

With slicer:

With Filters on this visual:

With Filters on this page:

In the case above, filtering on status will not affect your results for this measure, but filtering on other fields (such as filtering on policy_id) will still affect the value of the measure, for example:

However, if you want to use ALL or ALLSELECTED in the measure, then no matter what field is filtered, no matter if you use slicer or filter, it won't have any effect on the value returned by the measure.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.