difference of two averages and 2 slicers

[Pan_Forex]

Hey guys, I have a problem counting the difference of two averages. I keep getting a result of 0 despite filtering the data. I have a table that looks like this:

Player	Score	Player2	Score2
A	8	A	8
B	7	B	7
C	6	C	6
D	8	D	8

I simply added two additional columns to use them separately in the slicer, unfortunately it doesn't work 😀 

My visualization:

 

TEAM I and TEAM II are averages of selected players. I would like Team_results to count the difference in averages between teams after selecting players on both sides. 

Team_results = AVERAGE('Table'[Score])-(AVERAGE('Table'[Score2]))

the result I would like to achieve after selected players A, B in TEAM I and C, D in TEAM II. Average Team I=7.5, Average Team II=7. Team I - TEAM II= 0.5 

[Pan_Forex]

Thank you very much for your time and help 🙂

[johnt75 · Accepted solution]

Linking both slicers to the same table won't work, you need to create two new tables for the slicers, like

Team I = DISTINCT('Table'[Player])

Link both Team I and Team II to your existing table and use the player column from the new tables on the slicer.

You can then create measures like

Team I Avg =
CALCULATE ( AVERAGE ( 'Table'[Score] ), REMOVEFILTERS ( 'Team II' ) )


Team II Avg =
CALCULATE ( AVERAGE ( 'Table'[Score] ), REMOVEFILTERS ( 'Team I' ) )

Team results = [Team I Avg] - [Team II Avg]