Get highest value from a measure

[Wresen]

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 month in a measure (in this case 202111)

This needs to be in a measure  

[Wresen]

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]

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

[Wresen]

@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 · Accepted solution]

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]

One more stupied question

When we now have Max above all in the measuer , is it possible to filter month so it only show data from the month using the "max above all" like a filter

/Thanks

[Wresen]

Hi @Anonymous 

Thanks so much . Just what i was looking for.

[vojtechsima]

Hi, @Wresen 
I am not sure if I get it right,
but do you mean just MAX value of all of those?
You can use:

MaxMeasure = 
CALCULATE(MAX(YourColumn), ALL('Yourtable'))