Conditional Formatting Column Based Comparing Measure With Value in Column

[RamiGamal]

Hello There,

I am having a column chart where 

X: Machine

Y: Actual Performance

Where "Actual Performance" is a Measure, I have also table similar to the below

Machine	Target
A	90%
B	95%
C	85%

Now I want to conditional format the columns in the chart as:

If the Actual Performance >= Target then Green otherwise it shall be red.

I know it shall be done through conditional formatting by a field value but I am confused on how to construct the correct Measure.

Any help on this is much appreciated, Thanks

[RamiGamal · Accepted solution]

I have figured it out and I'm putting the solution here in case someone has a similar case:

1-Create a measure for your target

Target Measure = IF(DISTINCTCOUNT('Table'[Machine])=1,MAX('Table'Target))

Then another measure for conditional formatting

Conditional Format = IF([Performance]>= [Target Measure],"Green","Red")

Keeping in mind to have a relation between Machine columns If you have two table