Filter data

Hi, Harry_Tran 

You can create a Measure and then create a Table visual.

1 Invoice_meet_requirement =

VAR t =

    FILTER (

        'Table',

        'Table'[Product_ID]

            IN { "A", "C" }

            || 'Table'[Product_ID] IN { "Z123", "Z234", "Z345" }

    )

VAR num =

    COUNTROWS ( t )

RETURN

IF ( num > 1, "Meet the requirement", "DO NOT meet the requirement" )

2 Create a Table with 'invoice' Field and drag 'invoice_meet_requirement' to its visual filter

The result looks like this:

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.