Row by Row Conditional formatting

[andrewb95]

I have a table showing similar information to this:

	Sales Person A	Sales Person B	Sales Person C
Sector A	10	12	15
Sector B	11	13	14
Sector C	12	15	10

What this shows is for each sector the sales person has made X number of sales. 

In this basic example the average sales for Sector A is 12.3. Meaning Sales Person A is below average for this industry. 

In essence based on the different Sectors (in my real data I have 10+) I want to conditional format the sales persons numbers by averages. 

I had the idea of calculation average sales per sector as a measure but then I am not sure how to acheive my end goal. 

[amitchandak · Accepted solution]

@andrewb95 , assume you have measure sales, create a measure like this, and use that in conditional formatting using the field value option

Measure =
var _sales = [sales]
var _avg = calculate(averageX(Values(Table[sales Person]), [sales]), filter(allselected(Table), Table[Sector] = max(Table[Sector])))
return
Switch( True() ,
_sales < _avg , "red",
"green"
)