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.

     

Laurent88's avatar
Laurent88
New Member
2 years ago

Hello, Thanks for the reply!

 

I confirm my database has 60 columns per row. Would you mind giving me more detail on how to split (keeping the subsequent columns) and then filtering the split columns (if i understand correctly). 

 

Thanks,

Laurent