Max value

[brittent]

I am trying to create a measure that will display a max value from a column of temperatures within a space but I keep getting an error for duplicate values when using the max function. This table is utelizing data from azure data explorer and is constantly updating. How would I write a measure to display just the highest value from a column on a card without getting this error? The following is an example of the table:

Location	Heat Index
heat index 1	85
heat index 2	82
heat index 3	84
heat index 4	85
heat index 5	84

[DOLEARY85 · Accepted solution]

Hi,

this should work:

Measure 5 = CALCULATE(MAX('Table (4)'[Heat Index]),ALL('Table (4)'))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍