Power Pivot Dax formula assistance required

[Sumesh]

Hi,

I need to calculate the sales ratios for each expenses for different customer groups / outlets / month. I am attaching the relevant report with excel formulas. I would be requiring the dax formulas instead of excel formulas.

Sum of Value	Column Labels
	Customer_1		Customer_1 Total	Customer_2			Customer_2 Total	Net Profit / (Loss)
Row Labels	Outlet_1	Outlet_2		Outlet_1	Outlet_2	Outlet_3
Revenue	82,502​	81,633​	1,64,135​	82,474​	82,200​	82,987​	2,47,661​	4,11,796​
Sales	82,135​	81,522​	1,63,657​	82,462​	81,877​	82,624​	2,46,963​	4,10,620​
Other Income	367​	111​	478​	12​	323​	363​	698​	1,176​
COGS	-59,386​	-63,563​	-1,22,949​	-65,694​	-62,400​	-67,325​	-1,95,419​	-3,18,368​
COGS	-59,386​	-63,563​	-1,22,949​	-65,694​	-62,400​	-67,325​	-1,95,419​	-3,18,368​
Expnese	-18,381​	-18,354​	-36,735​	-18,487​	-18,075​	-18,332​	-54,893​	-91,629​
Staff Cost	-10,555​	-10,475​	-21,029​	-10,474​	-10,273​	-10,618​	-31,365​	-52,395​
Logistics Expenses	-3,721​	-3,804​	-7,526​	-3,891​	-3,710​	-3,743​	-11,344​	-18,870​
Advt. & Promo Expenses	-3,398​	-3,373​	-6,770​	-3,411​	-3,387​	-3,258​	-10,057​	-16,827​
Admin Expense	-707​	-702​	-1,409​	-710​	-705​	-712​	-2,127​	-3,536​
Net Profit / (Loss)	4,735​	-284​	4,451​	-1,707​	1,725​	-2,670​	-2,652​	1,799​
Dax formulas required for the below ratios
Gross Profit %	27.7%​	22.0%​	24.9%​	20.3%​	23.8%​	18.5%​	20.9%​	22.5%​
Staff Cost % to Sales	12.9%​	12.8%​	12.8%​	12.7%​	12.5%​	12.9%​	12.7%​	12.8%​
Logistics Expenses	4.5%​	4.7%​	4.6%​	4.7%​	4.5%​	4.5%​	4.6%​	4.6%​
Admin Expense	4.1%​	4.1%​	4.1%​	4.1%​	4.1%​	3.9%​	4.1%​	4.1%​
Advt. & Promo Expenses	0.9%​	0.9%​	0.9%​	0.9%​	0.9%​	0.9%​	0.9%​	0.9%​
Net Profit / (Loss) % to Sales	5.8%​	-0.3%​	2.7%​	-2.1%​	2.1%​	-3.2%​	-1.1%​	0.4%​

Please assist.