Invalid value error

[Fusion_Incense]

I have 4 columns (ex Cat1, Cat2, Cat3, Cat4) need to select Product Category from the same lists table in one column, How do I make it to where after Cat1 is selected, than Cat2 can not be the same value as Cat1, and Cat3, can not be the same value as Cat1, Cat2 and so on

[Steve · Accepted solution]

Valid If for Cat1:

(SELECT(MyTable[Product Categry], TRUE, TRUE) - LIST([Cat2], [Cat3], [Cat4]))

Valid If for Cat2:

(SELECT(MyTable[Product Categry], TRUE, TRUE) - LIST([Cat1], [Cat3], [Cat4]))

Valid If for Cat3:

(SELECT(MyTable[Product Categry], TRUE, TRUE) - LIST([Cat1], [Cat2], [Cat4]))

Valid If for Cat4:

(SELECT(MyTable[Product Categry], TRUE, TRUE) - LIST([Cat1], [Cat2], [Cat3]))

[Fusion_Incense]

@Steve Thanks, So I don’t need to put anything at the [Invalid value error] part? OK I’ll give it a try Thank you!

[Fusion_Incense]

Great, It worked, Thank you @Steve