Filter based on text: A or B or C or .. BUT NOT A + B + C + ...

[Anonymous]

Hello,

I have a sales report and multiple filters are applied: Segment, Collection, and Category. The values in the filters are text (i.e. shoes or bags or apparel). Now i want to view all orders, based on all values selected from the three categories. 

For instance, when selecting A from Segment, B from Collection, C from category, POWER BI shows orders that meet all the three conditions (A + B + C).

I want to see all the results that meet one or more of the conditions (A or B or C). 

Can someone help? Thanks in advnace !! 

br, Di

[Anonymous]

Add each column as a Slicer

Disabled interaction of each slicer on each other/ matrix table

Created measure

See sample file:

https://filebin.net/6a578upqb7gk3ju3

[Anonymous]

Hi, thanks to your reply. Although I am not sure if that is what i am searching for. 

Maybe we can use a more concreted example here. I want to find out how many customers have bought products, that meet at least one of the conditions: 

1 - Heel_Height_Group: "High 55+ mm"

2 - Collection_type: "SEM Collection"

3 - Occasion:  "Formal"

These 3 conditions come from 3 different filters. They are 3 different columns in the dataset. 

Now, if i select apply these conditions, i will see customers who have bought "High 55+ mm" AND "SEM Collection" AND "Formal". I dont want to see customers meeting all 3 conditions.

What i need, is to konw the total amount of distinct customers who bought "High 55+ mm" OR "B2B Collection" OR "Outdoor". I want the customers meeting at least one of the conditions. 

Can you please advise how? 

br, Di

[v-diye-msft · Accepted solution]

Hi @Anonymous ,

You are referring using OR condition in several slicers, please kindly refer to this article: https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/

[Anonymous]

much appreciated to your answer, it works now !!!

[Anonymous]

please provide file with sample data