Create a new table with double constraint

Question

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!&nbsp;ProductColourCustomerSale ValueStatus_SellOrdineABluPippo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100.000Evaso1BRossoFranco&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50.000Aperto2CBluCaio&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60.000Evaso3ABluTizio&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80.000Evaso4ELillaSempronio&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90.000Evaso5FNeroMimi&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100.000Aperto6GLimoneCoco&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80.000Evaso7AGialloPippo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20.000Aperto8BVerdeFranco&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50.000Evaso9CGialloCaio&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60.000Evaso10AGialloTizio&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80.000Aperto11EFuxiaSempronio&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90.000Evaso12FBiancoMimi&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100.000Evaso13GFragolaCoco&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80.000Aperto14&nbsp;&nbsp;&nbsp;

tamerj1 · Accepted Answer

Hi&nbsp;Paskk&nbsp;Please refer to atached sample file

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

Forum Discussion

Create a new table with double constraint

1 Reply

Related content

charticulator's constraints

MLV Constraints

If Fabric Mirroring lost Constraints

How to create drill-down matrix hierarchy with pre-aggregated data without double-counting?

Count function is doubling

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