Filter in culumn with multiple value

[mokrane_bob]

Hello i'm dealing with a column which has multiple values in Power Bi.

I'm trying to find a way to how to filter ?

Exemple : when i select Adidas in filter, i will have the two first rows.

i have to precise that i have 15 brands, and the output in Brand Column depends on the choice of people

I don't want to Split, and pivot the column because i will have a duplicated rows. is there any way ?

@DTSpowerbi @Anonymous @MaxPowerBI 

[MaxPowerBI]

Hi @mokrane_bob ,

I would add a separate table with two columns and filter in that table. Table could look like this: 

Brand multiple	Brand
Adidas, Puma, Tommy Hilfiger	Adidas
Adidas, Puma, Tommy Hilfiger	Puma
Adidas, Puma, Tommy Hilfiger	Tommy Hilfiger
Adidas, Nike, Asics	Adidas
Adidas, Nike, Asics	Nike
Adidas, Nike, Asics	Asics
Nike, Zara, Channel	Nike
Nike, Zara, Channel	Zara
Nike, Zara, Channel	Channel
Hugo Boss, Puma	Hugo Boss
Hugo Boss, Puma	Puma

Thus, you could make a relationship between your column and that new table.

Regards, Max

[mokrane_bob]

Hi  @MaxPowerBI 

It would be a greate solution if i have a constent input in the Column

but my problem is that the input in the Column changes every time. i can have Thousands of rows with multiple combinaison of those Brand.

[Zubair_Muhammad · Accepted solution]

@mokrane_bob 

You can use a MEASURE as visual filter.

Please see attached file with your sample data

Measure =
IF (
    CONTAINSSTRING (
        SELECTEDVALUE ( Data[Brand] ),
        SELECTEDVALUE ( FilterTable[Filter] )
    ),
    1
)