Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Paskk
Regular Visitor

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!

 

ProductColourCustomerSale ValueStatus_SellOrdine
ABluPippo        100.000Evaso1
BRossoFranco          50.000Aperto2
CBluCaio          60.000Evaso3
ABluTizio          80.000Evaso4
ELillaSempronio          90.000Evaso5
FNeroMimi        100.000Aperto6
GLimoneCoco          80.000Evaso7
AGialloPippo          20.000Aperto8
BVerdeFranco          50.000Evaso9
CGialloCaio          60.000Evaso10
AGialloTizio          80.000Aperto11
EFuxiaSempronio          90.000Evaso12
FBiancoMimi        100.000Evaso13
GFragolaCoco          80.000Aperto14

 

 

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Paskk 
Please refer to atached sample file

1.png

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

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

Hi @Paskk 
Please refer to atached sample file

1.png

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.