Dynamic coloring for based on average

[Anonymous]

Dears

I have team utilization matrix showing each team member solving ticket count, i want to change color of TT solved count based on average value

if total value below average of Total TT solved then color will be RED

if total value above average of Total TT solved then color will be Green

thanx

[amitchandak · Accepted solution]

@Anonymous , Try

if([Total TT solved] > calculate(averageX(values(Table[members]),[Total TT solved]),allselected(Table)),"Green","Red")