Forum Discussion

brittent's avatar
brittent
Microsoft Employee
3 years ago
Solved

Max value

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:

 

LocationHeat Index
heat index 1 85
heat index 2 82
heat index 3 84
heat index 4 85
heat index 5 84

 

  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    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 👍

1 Reply

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    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 👍