Forum Discussion

Paskk's avatar
Paskk
Regular Visitor
3 years ago
Solved

Create a new table with double constraint

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 Valu...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Paskk 
    Please refer to atached sample file

    Table 2 = 
FILTER ( 
    'Table',
    ISEMPTY (
        EXCEPT ( 
            { "Blu", "Giallo" },
            CALCULATETABLE ( 
                VALUES ( 'Table'[Colour] ),
                ALLEXCEPT ( 'Table', 'Table'[Product] )
            )
        )
    )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Paskk 
Please refer to atached sample file

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