Forum Discussion

MPetramalo214's avatar
MPetramalo214
Icon for Helper I rankHelper I
4 years ago
Solved

Creating a Measure to Get Max Value of a Measure

Hi everyone, I am trying to reference a line charts maximum value in a second measure for a different visual.   Is my line chart, the x-axis is date, and the y-axis is a measure that calcul...
Need Help
  • ALLUREAN's avatar
    ALLUREAN
    4 years ago

    In that case try this:

    Max Actual Occupancy =

    CALCULATE (

    MAXX(

    DISTINCT('Calendar'[Date]),

            [Actual Occupancy]),

             ALLSELECTED ('Calendar'))

     
MPetramalo214's avatar
MPetramalo214
Icon for Helper I rankHelper I
4 years ago

Very cool! Works perfectly as intended - I was also able to accomplish this with another measure

var __table = SUMMARIZE('Calendar','Calendar'[Date], "_-value", _Measures[Actual Occupancy])
return MAXX(__table, [_-value])

but your solution works in the exact format I needed it to! 

 

Thanks again!