Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
i have 2 tables:
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?
Solved! Go to Solution.
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
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
works perfect!