Using OR conditions between slicers in DAX

How to implement a logical OR condition between two slicers of a Power BI report, or of a PivotTable in Excel.
By default, when relying on more than one slicer they are considered in an AND condition. This video+article explains how to change this behavior using DAX.

[stevenfortier]

Wow, such a great video Alberto, I really like your way of teaching by starting with a first version of the measure that most of the people can come up with then improve and explaining what are the drawbacks of each technique.
Thank you!

[reneglaus]

Within 20 minutes I learned more than the last 6 months! This is a real eyeopener. Great, Thank you very much.

[lukeminikoski]

I've expended a lot of hours trying make OR working on my measures, it works, but with a lot of limitations :) Thank's, thank's a lot!

[igordemetriusalencar]

Absolutely amazing. I don't even know how to thank you, this will help me a lot in my current power bi project.

[nishantkumar]

Loved Set approach and it can only come from sql background.
Thank you so much for the clarity.
You're awesome!

[gavclark]

Amazing ! Brilliant demonstration of different ways to calculate the same thing ... but more importantly how to think when writing DAX !

[jijanice]

Amazing! Cannot stop following your videos and courses! Thanks a million!

[michaelmays]

Great video! I love how you show the different solutions - it really makes me think about functions I don’t know as well

[argokusumandani]

Thank you Sir!
I am happy that i learn DAX directly from the Grand Master of DAX.
🎉

[UU-rygt]

Amazing! You just woke up a detective inside, inspiring to try more and more. I wish I had a teacher like you in school ;)

[eugeneniemand]

Thanks this was really informative and just shows that you can obtain the same result in many different ways. There is not right or wrong, just different

[ozGold]

Excellent explanations Alberto. You're a genius.

[stevennye]

Excellent explanation, I liked seeing the different ways to solve a problem, too often a single solution is presented and it doesn't examine alternatives.

[paulasturla]

Fabulous! Thank you for make us see this options so clearly!

[ceciliocbaroperez]

Fantastic way of explaining. Great job! Thanks for sharing!

[DanielTavares]

Wow!!! Such a nice approach for learning DAX
👏👏👏

[marceloabbiatiprado]

You deserved more likes and viewers man. Ty for the lesson.

[NaraMeerammaTrust]

super. what an excellent video with various ways to achieve the goal. I loved it. helpful practically. I have more options now to implement if client requires.

[ashishmohan]

Hi Alberto Ferrari
You are amazing.
I like your way of learning and content deliverable and really really amazing.
Very big thanks to share with your useful deliverable.
i used your all logic in my day to day work.
your blank row logic is very useful and add-columns+Generate+Row

[senasolak]

such a great explanation! Thank you very much :) I have some questions about it, I have to implement a dashboard that contains the distinct number of customers with 27 slicers (categorical and continuous) and I want to add an AND/OR slicers in it. What would be the optimal way to do it? Thank you very much in advance :)