Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |