Forum Discussion

Wresen's avatar
Wresen
Icon for Post Patron rankPost Patron
4 years ago
Solved

Get highest value from a measure

Hi I have a measure (measure 2) that do a calulation and writes "above" if the value is higher then a specifeid value and shows it like table below .  Is it possible to get the max values of the mo...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Wresen ,

     

    I suggest you to add a filter like [Measure2] = "above" in your new measure.

    It should look like as below.

    Max above Month =
CALCULATE (
    MAX ( 'Table'[Month] ),
    FILTER ( ALL ( 'Table' ), [Measure2] = "above" )
)

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Wresen's avatar
Wresen
Icon for Post Patron rankPost Patron
4 years ago

Hi vojtechsima 
Since measure 2 is a mesure it can change if a month is "above" or not depning on filters in the report.
I wan the new measure to get the highest month and this case on the picture its 202111:
so the new measure should write 202111 in a new table if i put it there.

 

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
4 years ago

Wresen 
Then try to write measure as I sent in below post.

  • Wresen's avatar
    Wresen
    Icon for Post Patron rankPost Patron
    4 years ago

    vojtechsima  

    Thanks so much for your help but, I do not get it to work , it gives me the max value on the month table (max is 202210) , it does not "care" about measure 2 and that it filter it down to 202111.

    Then i might even get more complicated since i do not want to show the table (picture) , i just want the resalut (202111) in the table.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Wresen ,

       

      I suggest you to add a filter like [Measure2] = "above" in your new measure.

      It should look like as below.

      Max above Month =
CALCULATE (
    MAX ( 'Table'[Month] ),
    FILTER ( ALL ( 'Table' ), [Measure2] = "above" )
)

      Result is as below.

       

      Best Regards,
      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Wresen's avatar
        Wresen
        Icon for Post Patron rankPost Patron
        4 years ago

        Hi Anonymous 

        Thanks so much . Just what i was looking for.