Forum Discussion

Nivedita's avatar
Nivedita
Regular Visitor
4 years ago
Solved

Display the max value in a column

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.
Need Help
  • Thejeswar's avatar
    Thejeswar
    4 years ago

    Hi,

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

     

     

5 Replies

  • Samarth_18's avatar
    Samarth_18
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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

     

     

     

     

  • Thejeswar's avatar
    Thejeswar
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Nivedita
      Regular Visitor
      4 years ago

      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's avatar
        Thejeswar
        Icon for Super User rankSuper User
        4 years ago

        Hi,

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