slicer on list

[emilypinhasi]

Hi

i have 2 tables:

• tableA
  • column teams
    • row1 team1
    • row2 team2
    • row3 team3
    • etc
• tableB
  • column teams
    • row1: team1,team2
    • row2: team2
    • row3: team1,team3
    • etc

in a report, i show tableB rows, and would like to use tableA as slicer, get all rows that contain team1 for example. the problem is i cant get the rows with multiple teams in tableB to work

*i have a relationship between the 2 columns

how do i do that?

[v-juanli-msft · Accepted solution]

Hi @emilypinhasi

First deselect the relationship between these two tables.

Then create measures in Table A

selected item = SELECTEDVALUE(TableA[teams])

whether contains = SEARCH(SELECTEDVALUE(TableA[teams]),MAX(TableB[teams]),,BLANK())

To all rows that contain team2 for example, please drag measure [whether contains] in the visual level filter and set "show values when item is not blank"

Best Regards

Maggie

[emilypinhasi]

works perfect!