Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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%
Solved! Go to Solution.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsAdvance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.