Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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!

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Thank you so much, it worked fine!!!

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous

    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

     

    Best Regards

    Maggie

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank you so much, it worked fine!!!

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous

    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