OR Logic in single slicer values

[atul9063]

Hi,

I have slicer (with values Churn1,Churn7,Churn28 and No Churn),

Selecting churn7 on slicer would filter the below table for Churn='Churn7' or Churn='Churn1' ,similarly on selecting churn28, filter would be Churn='Churn1' or Churn='Churn7' or Churn='Churn28' .

Dataset

TPID           Churn

1	Churn1
2	Churn7
3	Churn1
4	Churn28
5	Churn7
6	No Churn

[v-jiascu-msft · Accepted solution]

Hi @atul9063,

There are some workarounds. But you should think again first. Because it's confusion. Please download the demo from the attachment.

1. Add an ID column to the slicer table. 

2. Don't establish any relationship.

3. Create a measure.

Measure =
VAR slicer =
    SELECTEDVALUE ( Table1[CHURNAME] )
VAR selected =
    CALCULATETABLE (
        VALUES ( Table1[CHURNAME] ),
        FILTER (
            ALL ( Table1 ),
            'Table1'[ID] <= MIN ( 'Table1'[ID] )
                && Table1[ID] > 0
        )
    )
RETURN
    IF (
        slicer = BLANK (),
        1,
        IF ( MIN ( Table2[Churn] ) IN selected, 1, BLANK () )
    )

Best Regards,