format highest value in a column

[jeffminder]

This is what I thought would work, but it highlights every value in the column.
Trying to highlight highest value in column using format rule below:

MAX(list([Average])) = [_THISROW].[Average]

[AleksiAlkio · Accepted solution]

Try with MAX(YourTableName[Average])=[Average]

[jeffminder]

Thank you, this worked.   Have a question...
When doing a comparison, what is the significance of A vs B?

A)  Max(YourTableName[Average]) = [Average]
B)  Max([Average]) = [Average]

Unclear why adding the table name to the evaluation makes a difference in how the evaluation is performed.

[AleksiAlkio]

Max([Average]) reads the "max value" from that row's column.. which is just one value. The MAX(Table[Column]) reads all rows from a table and picks the maximum value from that specified one column.

[jeffminder]

Thanks for clarifying...  always considered the difference as shorthand vs longhand...  There's more to it apparently.  🙂

[AleksiAlkio]

You're welcome!