Forum Discussion
Post PatronGet 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 month in a measure (in this case 202111)
This needs to be in a measure
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
- vojtechsima
Super User
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')) 
WresenHi 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
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.
