Forum Discussion

sv98917n's avatar
sv98917n
Icon for Helper I rankHelper I
6 years ago
Solved

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's avatar
    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

    Attached a sample file in the below, hopes to help you.

     

    Best Regards,
    Yingjie Li

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

sv98917n's avatar
sv98917n
Icon for Helper I rankHelper I
6 years ago

Thank you for your reply. This works slightly. When I apply this method and I select "Yes", the other values that would be "No" are there and not filtered out. They just appear as blank. Any insight? Thank you. 

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
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

Attached a sample file in the below, hopes to help you.

 

Best Regards,
Yingjie Li

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