How do you make a visual interact with 2 or more slicers in an OR and not AND way?

[Syndicate_Admin]

I have 2 segmentations: Locality and Customers.
In a table I want to place the list of the names of Customers that meet some of the conditions selected in the segmentations. That is, for example, if I select location = Argentina and Customers = Pepe, the table should show ALL customers who are from Argentina (even if they are not called Pepe) or who are called Pepe (even if they are not from Argentina).
I can't achieve this effect naturally, as segmentations act as DNA by default, meaning both conditions must be met.
How can I make my targets work as an OR? Any way to do it with DAX, to get the values that meet ANY of the conditions?

[Anonymous]

Hi Vcesano,

I'd like to suggest you extract table fields to create a unconnected table, and you can use these as source of slicer. Then you can write a measure formula to check and compare values to return flag and use this formula on visual level filter to filter records.

Regards,

Xiaoxin Sheng

[parry2k · Accepted solution]

@Syndicate_Admin there is a blog post on it, check it here