Display the max value in a column

[Nivedita]

Hello everyone

I want to display 7.8% on the card but it gives - 0.08 as net growth rate. 

I've added an index column to the table and used the below formula.

The formulae that I used - 

NetGrowthRate = CALCULATE(MAX(Overall[Net Growth Rate]),FILTER(Overall,Overall[Index]=MAX(Overall[Index])))

Need help. Thank you.

[Thejeswar]

Hi @Nivedita ,

Your DAX will try to return the Net Growth Value in the row with Index that matches the Max Index value. I used the same DAX the you gave

By that case, 0.08 is returned as the Index for that record is greater and matches with the MAX of Index column

This 0.08 if you convert as % will show 7.8% which is the record with max value for index

[Nivedita]

Hello Thejaswar. How do I show it in percentage?

My bad, looks like it's displaying the decimal value. How do I make it 7.8%?

Thank you for your response.

[Thejeswar · Accepted solution]

Hi,

Select the measure and change to % in the measure tools that appears when you select the measure

[Nivedita]

Thank you very much.

[Samarth_18]

Hi @Nivedita ,

Hope you have tried with directly taking max of Net Growth Rate column in Card visual like below:-

or If its affecting due to any other field then you can try below code in measure and use it on card visual:-

Measure =
CALCULATE (
    MAX ( 'Overall'[Net Growth Rate] ),
    ALLEXCEPT ( 'Overall', 'Overall'[Net Growth Rate] )
)

Thanks,

Samarth