Conditional Formatting in Power BI

[Robzx]

Hi

I am starting to play with Power BI and am trying to do some conditional formatting on a matrix.

The measure that I have written works but has hard-coded values. The conditional formatting itself is being done on the measure using the rules of if value is 0 then colour white, if 1 then colour red.

Conditional Formatting = MAXX(Resource, IF(Resource[Grade]="Consultant"&& [Efficiency Measure] <=.95, 1, IF(Resource[Grade]="Managing Consultant"&& [Efficiency Measure] <=.75,1, IF(Resource[Grade]="Senior Consultant"&& [Efficiency Measure] <=.85, 1, IF(Resource[Grade]="Principal Consultant"&& [Efficiency Measure] <=.75, 1, IF(Resource[Grade]="Director"&& [Efficiency Measure] <=.60, 1 ))))))

Is it possible to have a lookup against the Resource table rather than hard-coded values?

Resource Code	Resource Name	Department	Grade	Utilisation
			Consultant	0.95
			Managing Consultant	0.75
			Senior Consultant	0.85
			Principal Consultant	0.75
			Director	0.60

<tbody>
</tbody>

I have tried using,

IF ([Efficiency Measure] < Resource[Utilisation], 1, 0)

However, I get an error saying Utilisation is not a single value.

Any guidance will be gratefully received.