Measure connected with table cell

[ManishML]

I want to make something like : a table is connected with a measure, If the measure value is 5 and in a table if some of the cell having a value greater or equal then that, it simply diffrenciate that cell by a color or anything which could highlight. 

I tired this, but its not working.

Test2 =
VAR Value = ('Name'[Values])
RETURN
IF (
Value < ('Name'[Valuesss]), "#0E8155" 

[v-yadongf-msft · Accepted solution]

Hi @ManishML 

The measure I created:

Valueness = MAX('Name'[Values])/2

formatting = IF('Name'[Valueness] >= 5,"red")

Click “Values” field, check “Conditional formatting”-“Font color”.

Then check “Field value”-“formatting”.

Finally, you can simply differentiate that cell by a color like below:

If I misunderstand your demands, please provide some data screenshots (remember to hide sensitive information) to help us better solve your problem.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syk]

Check out the conditional formatting for the table visual, you can set background color and lots of other settings!

Apply conditional table formatting in Power BI - Power BI | Microsoft Docs