How to add Calculated rows in a PBI Matrix

[Anonymous]

Hi all,

I want to insert calculated rows to a power BI matrix. How do i add this?

I can add calculated columns. But not sure how to structure the data and what are the functions to use to do this;

	2018
Vol(KG)	100
Turnover	12,000
Cost	(8,000)
Gross Profit	4,000
Cost/KG	40
Gross margin	33.3%

This is what the matrix should look like. Cost/KG and Gross margin are calculated using above rows.

Please assist

[Stachu]

have a read here:

https://community.powerbi.com/t5/Desktop/Create-calculated-row/td-p/440613