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 t...
Need Help
  • Anonymous's avatar
    Anonymous
    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

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!!!