How to filter 3 columns with one data segmentation

[adrileosol]

Hello everyone!

I'm from Argentina, and I have a question for you!

I need to be able to filter data from 3 columns at a time with a single slicer. Is this possible?

For example, I have 3 columns with emails and I want it to show me all the rows that contain an email that I can dynamically filter in any of the columns.

Thanks a lot!

Adrián Solís.-

[amitchandak]

@adrileosol , Do you want to filter the same email in different measures?

One way is to join email with a common table having email and two join will inactive, you can activate them using userelationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

Of have table not connected with any of the column and you can measure like

Countrows(filter( Table, Table[email1]  in values(email[email] ) || Table[email2]  in values(email[email] ) || Table[email3]  in values(email[email] ) ) )

Or use three email dimension tables

[adrileosol]

Hello! Thanks for response!

I dont want to make a mesure.

I only want to filter, with a drop box, a filter visualization.

For example, with products to make it easy:

    Product 1   -   Product 2   -   Product 3

1  Banana             Tomato           Apple

2  Juice                 Soup               Banana

3  Rice                  Salad              Chicken

4  Apple               Banana           Coca Cola

I want to select "Banana" in a drop box (Filter - Segmentation) and the result in a table should be the rows 1, 2 and 4.

If i selecet "Apple" the result should be the rows 1 and 4.

I hope i was clear, sorry...