How to create composition ratio in powerBI ---2

[gaccho_na]

Hello,

I want to display output Matrix B from data table A.

Too difficult for me.

Please Help me !

data table A

Date	DIV	Att	value
2020/04	Net Sales	Actual	600,000
2020/04	Net Sales	Plan	590,000
2020/04	Cost of Sales	Actual	300,000
2020/04	Cost of Sales	Plan	310,000
2020/04	Gross Profit	Actual	300,000
2020/04	Gross Profit	Plan	280,000
2020/04	SGA expenses	Actual	120,000
2020/04	SGA expenses	Plan	120,000
2020/04	Operating income	Actual	180,000
2020/04	Operating income	Plan	160,000
2020/05	Net Sales	Actual	800,000
2020/05	Net Sales	Plan	810,000
2020/05	Cost of Sales	Actual	390,000
2020/05	Cost of Sales	Plan	400,000
2020/05	Gross Profit	Actual	410,000
2020/05	Gross Profit	Plan	410,000
2020/05	SGA expenses	Actual	125,000
2020/05	SGA expenses	Plan	130,000
2020/05	Operating income	Actual	285,000
2020/05	Operating income	Plan	280,000
2020/06	Net Sales	Actual	500,000
2020/06	Net Sales	Plan	490,000
2020/06	Cost of Sales	Actual	260,000
2020/06	Cost of Sales	Plan	250,000
2020/06	Gross Profit	Actual	240,000
2020/06	Gross Profit	Plan	240,000
2020/06	SGA expenses	Actual	120,000
2020/06	SGA expenses	Plan	130,000
2020/06	Operating income	Actual	120,000
2020/05	Operating income	Plan	110,000

output Matrix B
Slicer : Date = 2020/04

	Plan		Actual
	TTL Value Plan	composition ratio	TTL Value Actual	composition ratio
Net Sales	590,000	100.0%	600,000	100.0%
Cost of Sales	310,000	52.5%	300,000	50.0%
Gross Profit	280,000	47.5%	300,000	50.0%
SGA expenses	120,000	20.3%	120,000	20.0%
Operating income	160,000	27.1%	180,000	30.0%

[amitchandak · Accepted solution]

@gaccho_na , You need two measures

M1 = sum(Data[Value])

% = Divide(sum(Data[Value]), calculate(sum(Data[Value]), filter(allselected(Data[DIV]), Data[DIV] = "Net Sales" )))

Please find the attached file after signature