Calculate percentage of a return value against the sale value in Power BI

Question

I have a matrix in which there are companies, sale value, and return value.

I want to calculate that what percentage of the return value is from sales value

The sales value can be negative because there can be no sales.

How can I do it?

Any help would be highly appreciated.

Answer 1

You do this with measure

Percentage = sum(Table[Return value])/sum(Table[SALES VALUE])

Then select measure and click on % symbol in Measure tools. Numbers will be displayed in %.

Answer 2

Try with this example, Its posted in powerbi community.

https://community.powerbi.com/t5/Desktop/Measure-to-calculate-average-in-line-stack-bar-chart/m-p/1608563#M650205