Forum Discussion

SLI's avatar
SLI
Icon for Helper IV rankHelper IV
7 years ago
Solved

% in measure

Hello

 

how can i do to display the % in a calculated measure of power bi

 

My calculated measure= DIVIDE(sum(BI_facture[montant]);SUM(BI_devis[montant du devis]))*100

 

Thanks in advance

 

Sabrina 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi SLI

     

    Just concatenate % with your measure.

     

    My calculated measure= DIVIDE(sum(BI_facture[montant]);SUM(BI_devis[montant du devis]))*100&"%"

     

    Regards,

    Vivek 

     

     

  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi SLI,

    Based on my test, you could refer to VivekC's solution and you could also set the format in 'Modeling':

    Regards,

    Daniel He

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi SLI

     

    Just concatenate % with your measure.

     

    My calculated measure= DIVIDE(sum(BI_facture[montant]);SUM(BI_devis[montant du devis]))*100&"%"

     

    Regards,

    Vivek 

     

     

    • Sansudhi8's avatar
      Sansudhi8
      Icon for Helper III rankHelper III
      7 years ago

      Dear ViveKC,

       

      Could you please let me know how to change format to 2 decemail point of percentage. 

       

      Please see my below example.

       

      Thank you

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Sansudhi8

         

        Select that column that you have have change upto 2 decimal points

        and under the Modeling tab click on formatting section.

         

        find below snaps for more clarification 

         

         

        Regards,

        Vivek 

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi SLI,

    Based on my test, you could refer to VivekC's solution and you could also set the format in 'Modeling':

    Regards,

    Daniel He