Forum Discussion

s15's avatar
s15
Helper III
9 years ago
Solved

Convert a numeric to percetange after using measure

I have two values: Sales and Gross Sales. I created a measure to calculate the margin. The measure looks like below

 

Margin = 100 - (SUM(financials[ Sales])/SUM(financials[Gross Sales])*100)

 

 

 

Is there a way to display the value in percentage. It's 7.20%

Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    Hi s15,

     

    First of all change your measure to: 

    Margin = 1 - (SUM(financials[ Sales])/SUM(financials[Gross Sales]))

    Then just select the measure and on the bar choose Modeling and Percentage and your measure will be in %.

     

     

    Regards,

    MFelix

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    9 years ago

    Hi s15,

     

    First of all change your measure to: 

    Margin = 1 - (SUM(financials[ Sales])/SUM(financials[Gross Sales]))

    Then just select the measure and on the bar choose Modeling and Percentage and your measure will be in %.

     

     

    Regards,

    MFelix