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

     

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

 

  • emilypinhasi's avatar
    emilypinhasi
    Frequent Visitor
    7 years ago

    works perfect!