Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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êsUser | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |