Forum Discussion

emilypinhasi's avatar
emilypinhasi
Frequent Visitor
7 years ago
Solved

slicer on list

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?

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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

     

2 Replies

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

    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