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.
Article and sample download: https://sql.bi/66373?aff=yt
How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: https://www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt