2 Tables. 1st table relating to slicer. 2nd table related to a field in table

[DebbieE]

I have the following Data set

Person Win Lose Draw Plays Team

A         3      7        0       10     Blue

B         5      8        1       13     Blue

C         7      10        3       20     Blue

D         10      4        2       16     Red

E         11      1        12       23     Red

I need a slicer to choose the player and show their results in a table.

Then I need a second table showing the results of everyone in the red team

So if you choose Person A. You see there results

Under this another table with 3 rows for all the Blue Team players

Is there any way of doing this at all. Any help would be really appreciated

[DebbieE · Accepted solution]

Great,

Ill have a go at this tomorrow and let you know

[LivioLanzo · Accepted solution]

@DebbieE

check out my file: https://1drv.ms/u/s!AiiWkkwHZChHjyyt8MpcD-3jglQf

[v-frfei-msft · Accepted solution]

Hi @DebbieE,

I made one sample for your reference.

1. Create a calculated table.

Person = DISTINCT(Table1[Person])

2. Create the masures as below and create two table visual and make both of them filterd by the measures seperatly.

Measure = var sele = SELECTEDVALUE(Person[Person])
var team = CALCULATE(MAX(Table1[Team]),FILTER(ALL(Table1),Table1[Person]=sele))
return
IF(MAX(Table1[Team])=team,1,0)

Measure2 = var sele = SELECTEDVALUE(Person[Person])
var team = CALCULATE(MAX(Table1[Team]),FILTER(ALL(Table1),Table1[Person]=sele))
return
IF(MAX(Table1[Team])=team,0,1)

For more details, please check the pbix as attached.

Regards,

Frank

[DebbieE]

All of these are great solutions,

Thanks everyone 

[Anonymous]

1) Add the "Person" column as a slicer. Lets call this SLC1

2) Add a Matrix Table to the page and add "Win, Lose, Draw, Plays" to it. Lets call this MT1

3) Add another matrix table and this time add all the columns into it apart from "Team". Lets call this MT2

"Team" will be added to "Visual level filters" where you can edit the dropdown and only select "Red"

4) Copy above matrix table and paste it as a new table, then just change filter from "Red" to "Blue". Lets call this MT3

After that refer to below link to see how to edit interactions

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

SLC1 should only interact with MT1

MT1 should not interact with anything

MT2 should not interact with anything

MT3 should not interact with anything

[DebbieE · Accepted solution]

Great,

Ill have a go at this tomorrow and let you know

[LivioLanzo · Accepted solution]

@DebbieE

check out my file: https://1drv.ms/u/s!AiiWkkwHZChHjyyt8MpcD-3jglQf