Forum Discussion

Laurent88's avatar
Laurent88
New Member
2 years ago
Solved

Slicer filtering

  Hi Community   I am a recent user of PowerBI and so far, it works great for me. I however have a question that I really struggle to answer, despite browsing through the forum. Here it is:   In...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Laurent88 

    You can refer to the following sample.

    Sample data

    Samle slicer data 

    Create a measure and put the measure to the table visual filter

    Measure =
VAR a =
    COUNTROWS (
        FILTER (
            VALUES ( Slicer[Slicer] ),
            CONTAINSSTRING ( SELECTEDVALUE ( 'Table'[Column2] ), [Slicer] )
        )
    )
RETURN
    IF ( a > 0, 1, 0 )

     

    Output

     

    Best Regards!

    Yolo Zhu

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