Slicer based on values of multiple measures placed on a Table visual

[giramswa]

Hi All,

I have a table visual with some columns and some measures as below:

Col_1	Col_2	Col_3	Col_4	Measure_1	Measure_2	Measure_3	Measure_4
APAC	331	221	abcd	1	0	1	0
EMEA	332	222	efgh	1	1	0	1
EUROPE	333	223	jklm	1	0	1	0
AMERICA	334	224	nopq	0	0	0	1

I need to provide option to classify records in above table visual as per below conditions:
1. IF(measure_1 = 1 && measure_2 =1, THEN "ABC Compliant" , ELSE "ABC Non-Compliant")
2. IF(measure_3 = 1 && measure_4 =1, THEN "LML Compliant", ELSE "LML Non-Compliant")

Need to provide one Slicer with below 5 options:

1. Only ABC Compliant Records
2. Only LML Compliant Records
3. Show both -- Compliant (ABC & LML) 
4. Show both -- Non-Compliant (ABC & LML) 
5. Show ALL

As I can map only one column(and not measure) to slicer, how can I achieve this?

[giramswa]

@Anonymous Thank you for your inputs, your suggested approch resolved my issue.

[Anonymous · Accepted solution]

Hi  @giramswa ,

Here are the steps you can follow：

1. Create a table with Enter data.

2. Create measure.

Measure_true1 =
    IF(
    [Measure1]=1&&[Measure2]=1,"ABC Compliant",
        "ABC Non-Compliant"
)

Measure_true2 =
    IF(
        [Measure3]=1&&[Measure4]=1,"LML Compliant","LML Non-Compliant")

Flag =
SWITCH(
    TRUE(),
    MAX('Slicer_Table'[Slicer])="Only ABC Compliant Records"&&
   [Measure_true1] ="ABC Compliant",1,
    MAX('Slicer_Table'[Slicer])="Only LML Compliant Records"&&
    [Measure_true2] ="LML Compliant",1,
    MAX('Slicer_Table'[Slicer])="Show both -- Compliant (ABC & LML)"&&
    [Measure_true1] ="ABC Compliant"&&[Measure_true2] ="LML Compliant",1,
    MAX('Slicer_Table'[Slicer])="Show both -- Non-Compliant (ABC & LML)"&&
    [Measure_true1]="ABC Non-Compliant"&&[Measure_true2]="LML Non-Compliant",1,
    MAX('Slicer_Table'[Slicer])="Show ALL",1)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

If you need pbix, please click here.

Best Regards,

Liu Yang

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

[amitchandak]

@giramswa , You need create a new measure like

IF( [measure_1] = 1 && [measure_2] =1,"ABC Compliant" ,"ABC Non-Compliant")

M2=

IF([measure_3] = 1 && [measure_4] =1, "LML Compliant", "LML Non-Compliant")

Then you need dynamic segmentation using an independent having the values

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

https://www.daxpatterns.com/dynamic-segmentation/

[giramswa]

Thank you for your inputs.