How can i show average as a percentage of a grouping?

[Blue246]

How can i create a measure to show average Plays by Person, Per Day as a percentage (higher or lower) than the average Plays of that person's team? For simplicity i kept the table to one date for this question.

Lets say i have a table:

Player	Moves	Team	Date
Ted	Left	Red	1/1/2001
Ted	Left	Red	1/1/2001
Ted	Right	Red	1/1/2001
Bill	Left	Blue	1/1/2001
Bill	Right	Blue	1/1/2001
Mark	Left	Green	1/1/2001
Luke	Right	Red	1/1/2001
Luke	Right	Red	1/1/2001

I need to calculate each players average moves by day as a percentage compared to the average moves by play players team.

In a Power BI Table it should look something like: This doesnt match the above table it's just for an example.

Player	Avg Moves Per Day	Percentage Vs Team Avg
Ted	3	50%
Bill	2	75%
Mark	1	-30%
Luke	2	-45%

Basically a positive % is how much that persons avg is above their specific teams average and vice versa for a negative percentage.

Thanks for the help!

[Greg_Deckler · Accepted solution]

@Blue246 So like this? PBIX below sig.

Measure = 
    VAR __Average = AVERAGEX( SUMMARIZE( ALL('Table'), [Player], [Date], "__Moves", COUNTROWS( 'Table' ) ), [__Moves] )
    VAR __Percent = DIVIDE( COUNTROWS('Table') - __Average, __Average )
RETURN
    __Percent