colour highest value in each column of a matrix table

[CLANG10]

Hi,

    I have a matrix table which i want to colour the highest value in each column. I wrote a measure below: 

MAXCOLOR = VAR MAX% = MAXX(ALLSELECTED(Table), Table[Week]) RETURN IF(MAX%=MAX(Table[Week]), "#E6007E")

But not able to insert this measure as field in cell conditional formating. 

Would need advise on the Measure. Thanks!!

[Yashh]

Hello @CLANG10 

Use cell elements and then click on fx and then do conditional formatting for each column.

Best regards

Yashh

If you like give kudos and mark it as a solution if I was able to solve your problem.