Max value for a calculate table

[Anonymous]

Hello All,

I need you support to calculate the max value of a calculate table. In my model i need to create the calculated table as below:

the % is already calculated and is a measure. the month-year is a coulms in the calendar table.

recap of the table below:

MESE&ANNO='CALENDAR_SOSP'[MESE&ANNO]

%=PERCENTUALE 

The result that i need is the max so

ago-20 = 92%

thank you very much for the answer

massimiliano

[v-kelly-msft]

Hi @Anonymous ,

Try the measure as below:

maxvalues=MAXX(VALUES('Table'[MESE&ANNO]),%)

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , if it is already a table then you can this measure along with MESE&ANNO

calculate(max(Table[MESE&ANNO]) , filter(allselected(Table), Table[%] =max(Table[%])))

[Anonymous]

thanks @amitchandak  unfortunatelly is not a table, i think before use your formula i need to create a calculated table like this. 

The % is already calcuted as measure but not for each months. should i create a calculated table with this info? 

[v-kelly-msft]

Hi @Anonymous ,

Is your issue solved？Does my suggestion work ?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!