Target by Work Type

[danieldors]

I have  employees grouped  under Work Type, Im trying to color coordinate to show those producing less than the average for their own work type.

=if(sum([PPE History.Total Transactions])/sum([Hours Worked])>(sum([PPE History.Total Transactions])/sum([Hours Worked])),Green(),rgb(178,36,36))

Thank you.

[AdiPai]

You can use the master measure and define colours in the master measure based on segment values