Color highest value in a table column

[CLANG10]

Hi, 

    I wanted to insert background colour for highest value (i.e. 386) in a table column. Wrote a measure "COLOR MAXCT" and apply in field value formatting, but the results colour all rows in the column instead. Seek advise on how Measure should be written to correct this. Thanks!

[Ahmedx]

VAR MAXCT = MAXX(Al('таблица'),[VALUE]) RETURN IF(MAX('table'[VALUE])=MAXCT,"#E6007E") 

[Arul · Accepted solution]

@CLANG10 ,

try this measure,

COLOR MAXCT = 
VAR _max = MAXX(ALLSELECTED('Tablename'),'Tablename'[VALUE])
RETURN IF(_max = MAXA('Tablename'[VALUE]),"#E6007E")

Thanks,

Arul