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 us...
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

     

     

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