Create a new table with double constraint

[Paskk]

I would like to create a new table that contains only the products sold together in blue and yellow colors. Below is the input table.

Thank you very much!

Product	Colour	Customer	Sale Value	Status_Sell	Ordine
A	Blu	Pippo	100.000	Evaso	1
B	Rosso	Franco	50.000	Aperto	2
C	Blu	Caio	60.000	Evaso	3
A	Blu	Tizio	80.000	Evaso	4
E	Lilla	Sempronio	90.000	Evaso	5
F	Nero	Mimi	100.000	Aperto	6
G	Limone	Coco	80.000	Evaso	7
A	Giallo	Pippo	20.000	Aperto	8
B	Verde	Franco	50.000	Evaso	9
C	Giallo	Caio	60.000	Evaso	10
A	Giallo	Tizio	80.000	Aperto	11
E	Fuxia	Sempronio	90.000	Evaso	12
F	Bianco	Mimi	100.000	Evaso	13
G	Fragola	Coco	80.000	Aperto	14

[tamerj1 · Accepted solution]

Hi @Paskk 
Please refer to atached sample file

Table 2 = 
FILTER ( 
    'Table',
    ISEMPTY (
        EXCEPT ( 
            { "Blu", "Giallo" },
            CALCULATETABLE ( 
                VALUES ( 'Table'[Colour] ),
                ALLEXCEPT ( 'Table', 'Table'[Product] )
            )
        )
    )
)