Forum Discussion

bhanes22's avatar
bhanes22
Icon for Helper I rankHelper I
5 years ago
Solved

Slicer with distinct values from a column that has multiple values?

Hey All,   I'm very much a novice when it comes to PowerBI, so please be gentle here. I have an issue where I have a column named specifications in my item master table that has multiple different ...
Need Help
bhanes22's avatar
bhanes22
Icon for Helper I rankHelper I
5 years ago

This worked perfectly! Thank you so much for your help! One quick question and its not the end of the world if this is not possible but it doesn't seem to filter properly on multiple spec selections, would that be possible to filter on multiple specs? 

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

Hi bhanes22 

My previous measure only deals with a single select situation. For multiple specs selections, you could use below measure and set show items when the value is greater than 0.

Flag 2 = 
CALCULATE (
    COUNTROWS ( 'master table' ),
    FILTER (
        'master table',
        SUMX (
            specifications,
            SEARCH ( specifications[spec], 'master table'[specifications], 1, 0 )
        ) > 0
    )
)

 

I found above measure from below blog, you could refer to it for more ideas.

SEARCH FUNCTION WITH A LIST VALUE - Microsoft Power BI Community

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.