Using a Yes/No Measure As a Slicer/Filter

Hello Community, I have a measure that returns Yes/No based on duplicate values that is dependant on a date slicer (which is why its in a measure). Is there a way to make a yes/no drop down page...

Need Help

v-yingjl

6 years ago

Hi sv98917n ,

1. Create a Slicer table manually and use it as a slicer:

2. Create a measure like this:

Measure = 
VAR _count =
    CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[date] ) )
RETURN
    IF (
        NOT ( ISFILTERED ( Slicer[Slicer] ) ),
        _count,
        IF (
            SELECTEDVALUE ( Slicer[Slicer] ) = "Yes"
                && _count >= 2,
            "Yes",
            IF ( SELECTEDVALUE ( Slicer[Slicer] ) = "No" && _count < 2, "No" )
        )
    )

default statususing a slicer