How to use slicer with conditions

shikhavidyarthi — Mon, 07 Aug 2023 17:01:06 GMT

I have a slicer with few items in it like A,B,C,D_Total,D, E,F,G. I have multi-selection option. However, I want to add a condition here. Whenever I select D and D_Total together, D should be disabled automatically and only D_Total should reflect the rest data in tab.

Re: How to use slicer with conditions

Anonymous — Tue, 08 Aug 2023 03:04:03 GMT

Hi shikhavidyarthi ,

I suggest you to create an unrelated Dimitems table for slicer.

Measure:

Filter = VAR _VALUES = VALUES ( DimItems[Items] ) VAR _VALUESINCONDITION1 = FILTER ( _VALUES, [Items] <> "D" ) RETURN IF ( ISFILTERED ( DimItems[Items] ), IF ( AND ( "D" IN _VALUES, "D_Total" IN _VALUES ), IF ( MAX ( 'Table'[Items] ) IN _VALUES && MAX ( 'Table'[Items] ) <> "D", 1, 0 ), IF ( MAX ( 'Table'[Items] ) IN _VALUES, 1, 0 ) ), 1)

Add this measure into visual level filter and set it to show items when value = 1.

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic How to use slicer with conditions in DAX Commands and Tips

How to use slicer with conditions

Re: How to use slicer with conditions