Measure as a Filter assistance

Hi EAB1977 ,

I agree with amitchandak's reply.  As far as I know, Power BI only supports us to add measure as a filter in visual level filter. So we couldn't add measures as filter in Page/Report level filter. Page/Report level filter could only add columns.

So I suggest you to add [IsException] measure as a filter into visual level filter in the visuals you want to filter by it.

I think filter could not identify  True() or False(). Try to use 1 to replace True() and 0 to replace False().

IsException =
IF (
    OR (
        MeasureTable[SumOfLostProduction] < -1000,
        SUM ( Data[Output Cup Counts] ) = 0
    ),
    1,
    0
)

Let [IsException] measure to show items when the value =1 in visual level filter.

Best Regards,
Rico Zhou

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