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'))

     
ALLUREAN's avatar
ALLUREAN
Icon for Solution Sage rankSolution Sage
4 years ago

Hi, MPetramalo214 

 

Let suppose you measure in visual is [HotelOccupancy].

 

Create new measure like:

 

MaxHotelOccupancy = 

VAR MaxDate = MAX('Datetable'[Date])

RETURN

CALCULATE([HotelOccupancy],
FILTER(ALL('Datetable'),
'Datetable'[Date] = MaxDate ))

 

 

  • MPetramalo214's avatar
    MPetramalo214
    Icon for Helper I rankHelper I
    4 years ago
    Max Actual Occupancy = 
var maxDate = MAX('Calendar'[Date])
return
    CALCULATE(
        [Actual Occupancy], 
        'Calendar'[Date] = maxDate
    )

     

    I tried the above measure, and its returning the same value as actual occupancy for each day

    • ALLUREAN's avatar
      ALLUREAN
      Icon for Solution Sage rankSolution Sage
      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!