Calculate Measures in Slicer with default values

[Narukkp]

Hi Team,

Can we use the measure value in Slicer with default values. Below is the my scenario

Measure Val =IF(Measure1+meausre2+measure3=3,1,0)

Measure String=IF(Measure Val=1,”YES”,”NO”)

Below is the existing Report

Name	Meaure1	Measure2	Measure3	Measure Val	Measure String
A	1	0	1	0	NO
B	1	1	1	1	YES
C	1	1	1	1	YES

Required Output is Default loading should be YES values but when the user is select the No in slicer then we need to display NO values.

Could you please let me know how to add above Measure String measure in Slicer with “Yes” default values.

[v-frfei-msft · Accepted solution]

Hi @Narukkp ,

As we know, we cannot add a measure to a slicer. Here we can add the measure to the visual level filter to make the measure is YSE to get the filtered visual.

Regards,

Frank

[Nishantjain · Accepted solution]

@Narukkp 

You can use ISFILTETED function to find out is a field has filters applied to it. You can then use the default value if it is not filtered

Measure Val with Default =
IF (
    ISFILTERED ( [Measure String] ),
    IF ( Measure1 + meausre2 + measure3 = 3, 1, 0 ),
    CALCULATE (
        IF ( Measure1 + meausre2 + measure3 = 3, 1, 0 ),
        [Measure String] = "YES"
    )
)

[v-frfei-msft · Accepted solution]

Hi @Narukkp ,

As we know, we cannot add a measure to a slicer. Here we can add the measure to the visual level filter to make the measure is YSE to get the filtered visual.

Regards,

Frank

[Narukkp]

Hi ,

If you add the page level or visuvlization level filter then end user may not be able to select the NO in slicer. This is not i am expecting

[v-frfei-msft]

Hi @Narukkp ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

[Narukkp]

Hi Team,

Does any one having any idea please help on this.