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

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