cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sonamyan Frequent Visitor
Frequent Visitor

How to Filter for One Value in A Multiple Valued Column

Hello guys, 

 

I want to choose one of the columns on the left table to get all the values in the right table that contain the same value. 

 

 

As highlihgted in the picture, I want to get all the rows that contain 'Unemployment Insurance'  on the right table. 

 

 

Thanks s lot!

Power bi community question.PNG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
sonamyan Frequent Visitor
Frequent Visitor

Re: How to Filter for One Value in A Multiple Valued Column

Thank you so much, it worked fine!!!

3 REPLIES 3
Community Support Team
Community Support Team

Re: How to Filter for One Value in A Multiple Valued Column

Hi @sonamyan

Assume "visit reason values" and "visit reason" are two columns in different tables.

add [ visit reason values] in the slicer, create measures

selected value = SELECTEDVALUE(Sheet3[values])

show = IF(NOT(ISERROR(FIND([selected value],MAX(Sheet4[reason])))),1,0)

add measure [show] in the visual level filter and show items when value is 1

4.png

 

Best Regards

Maggie

Community Support Team
Community Support Team

Re: How to Filter for One Value in A Multiple Valued Column

Hi @sonamyan

I notice that you want to create some measures in your another post,

Why do you need to create measures?

could tell me what's wrong you meet when you use the methods v-yulgu-msft provides?

With more details, i would give a more useful solution.

 

Best regards

Maggie

sonamyan Frequent Visitor
Frequent Visitor

Re: How to Filter for One Value in A Multiple Valued Column

Thank you so much, it worked fine!!!