Power BI Dynamic filtering

I need to filter my Order table based on the Conditions table. The catch is that my conditions table can have any number of rows.

I have my tables in the below format - 

The consitions need to be applied in the following way - 

1. For each row in the conditions table - it's an AND condition between the 3 codes. 

2. Then we UNION the results of each row

For the above table I have, my results would be -

1. For C1 - 2, 3, 7, 8 

2. For C2 - 4, 6

3. For C3 - 10

Final results - 2, 3, 4, 6, 7, 8, 10

The equivalent SQL in this case would be - 

SELECT OrderNo FROM Orders WHERE

(BillTo IN (B1, B2))   OR        --C1

(Shipper IN (S1, S3) AND Receiver IN (R3)) OR     --C2

(BillTo IN (B3, B4) AND Shipper IN (S3, S4) AND Receiver IN (R2, R3, R4))   --C3

I need to be able to loop through the conditions table as the number of condiiton sets can change dynamically.

Can someone please help with the implementation in Power BI?