Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Max value for a calculate table

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

Need Help
Tips and Tricks

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        v-kelly-msft
        Community Support
        5 years ago

        Hi Anonymous ,

         

        Is your issue solved？Does my suggestion work ?

        Best Regards,
        Kelly

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

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    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!