or logic slicer

Question

Is there a way to implement OR logic between 2 slicers?&nbsp;I have a table with multiple columns and I want to be able to see items that meet either of the 2 criteria.&nbsp;Example:Type&nbsp;&nbsp; Color&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Other columns....A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RedA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BlueA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GreenB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RedB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RedB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Green&nbsp;I want to see anything on my resulting chart that is EITHER red OR Type A (5 results here). My graphs still need to maintain all of the data from the "other columns," like a regular slicer,&nbsp;so I can't just get an overall sum.Thanks.

stachu · Answer

if you create a new, separate tables for&nbsp;Color &amp; Type, and use them for slicers (without joining them with original table), then this syntax should work:Measure = 
VAR Summary = 
    SUMMARIZE(ALL('Table'),'Table'[Color],'Table'[Type])
VAR FilteredSummary = 
    FILTER(
        Summary,
        [Color] IN VALUES(Color[Color])
        || [Type] IN VALUES('Type'[Type])
    )
RETURN
CALCULATE(SUM('Table'[Value]),FilteredSummary)replace the blue syntax with whatever measure you want to show on the visuals

anonymous · Answer

Have a look at this:&nbsp;https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/

sp8 · Answer

Thanks.Once I changed SUM to COUNT, I was able to get it working on visuals that only used fields from that original table.&nbsp;As soon as I added a field from a different table (with relationship to the first), the filter was basically removed and the table went back to showing all of the data.I tried adding the measure to a slicer so that I could force it to only see where the measure was 1, but that's apparently not allowed.&nbsp;Any further suggestions?

v-jiascu-msft · Answer

Hi&nbsp;sp8,
&nbsp;
Can you share a dummy sample please?
&nbsp;
Best Regards,
Dale

sp8 · Answer

Product table:Type&nbsp;&nbsp; Color&nbsp;&nbsp;&nbsp;&nbsp; Serial NoA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Red&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Blue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Green&nbsp;&nbsp;&nbsp;3B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Red&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Red&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Green&nbsp;&nbsp;&nbsp; 6&nbsp;Sales Table:Serial No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Customer&nbsp;&nbsp;&nbsp;&nbsp; Month1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; March2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Joe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; April3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; April4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; May5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bob&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; May6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Joe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; May&nbsp;I want to see a table visual/chart that shows sales (by customer) of anything&nbsp;RED or type A.&nbsp;When I use the code suggested and only use the Product Table, everything is great.When I add the "by Customer" information from the Sales Table, suddenly I can see all of the entries, not just the items that are red or type A.In the table visual, if I add the measure as a column name, it does show "'1" for anything in my OR filter and blank for anything not in my OR filter. But, they are still shown on the visual.

Forum Discussion

or logic slicer

7 Replies

Related content

Slicer by logic conditions

Logic problem?

Reusable slicer choices logic

FX Conversion Logic

Slicer with AND Logic