Using OR conditions between slicers in DAX 

do you think its allow Country=India || State="Alaska'? i mean does it show two rows? its not working in My case. both State and Country from Same table in my case

No, unfortunately it is not possible to create code that works with any slicer placed in the report.

The crossjoin could be expensive, it depends on the number of unique values you have in the two slicers. However, you might be surprised about the performance, which is quite good even though you have a few thousands of items in one slicer and only a couple of items selected in the other. I suggest you try and benchmark it. You probably want the videos in this playlist: ru-vid.com/group/PLU6II7MW-aiIees6mrPfdjt9c8noi7P66

@@SQLBI Thanks a lot appreciate it!

You can download the sample files in related article linked in the description. If you want the underlying SQL database, you can find it in the companion content of our book you can download here: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/ (you don't have to but the book to download the companion content).

@@SQLBI Thank you very much

@@SQLBI Thank you very much.

You cannot. Two slicers on the same columns cannot be recognized in the DAX measure. You see the result of the two filters.

We have videos for DAX Patterns available at www.daxpatterns.com explaining how the patterns work. The goal of those videos is not to teach DAX, they should speed up the ability to customize the formulas assuming the reader already knows DAX.

This is valid only for additive measures. The technique shown in the video is measure-agnostic, it also works with non-additive measures (like DISTINCTCOUNT, time intelligence, ratios, and others).

@@SQLBI very true, great point!

Duplicated values don't affect the filter context. SUMMARIZE doesn't lose data lineage in the "groupby" columns!

@@SQLBI Thank you for taking the time to respond to my queries. Here is a link to a post I wrote back in 2014 to get OR Filtering in Excel. I went with the CROSSPRODUCT approach: strugglingtoexcel.com/2014/02/21/permutations-lists-excel/

@@SQLBI Lovely video. It is very apparent that you pour in a lot of effort into coming up with illustrations that showcase exactly how things work with no room for doubt. Very thankful for making these videos free to watch. God Bless!

You should write "= SELECTEDVALUE...) but it wouldn't be better and would work only with a single selection. This implementation works also with multiple selection.

@@SQLBI That’s correct. Didn’t think that way. Thanks! 👍🏻

The speed depends on the cardinality of the slicers (e.g. 3 items x 4 items = 12 possible combinations, which is a small number), not on the number of rows you have in the model. But if you use slicers with millions of possible selections each, you certainly have performance issues. Hundreds/thousands of items shouldn't be a big issue if you select just a few items in each slicer.

You may use a similar technique, but for the between it's easier to use the proper slicer in Power BI

@@SQLBI Hi there, thanks for the response. But could you ellaborate? How would I make two between slicers effact the page in an OR manner?

Between is not an or - by saying "between" you want an AND, like >= 2 AND

In order to remove the filters existing on the two grouped columns without losing other filters.

This is a very interesting question, thanks. The reason is that I want to teach how to find a solution, rather than the solution itself. In your daily reporting requirements, you will quite never face the exact same situation I show during the demo. To me, teaching means giving you the tools needed to face any unknown scenario. If I only show one solution, maybe the best one, you will be fine if you face that scenario, but you will be in trouble with a different scenario. If, on the other hand, I teach you how to find a solution, then you will be able to solve any scenario. I know, it is a harder path... nonetheless, much more rewarding at the end.