pivot table with dynamic calculation

AlwaysBI — Thu, 21 Mar 2019 10:14:31 GMT

I am new to PowerBI, I have a table in below and would like to pivot it with a subtotal by type. I have created a measure, If I want to pivot the table by SKU how can I archive the result I want?

First Class Total =
VAR ClassData= SUMMARIZE(FILTER(NEWTable,NEWTable[Type] = "First Class"),NEWTable[Outlet],"Total",SUM(NEWTable[value]))
RETURN
SUMX(ClassData,[Total])

NEWTable

Outlet	Transaction_Date	Type	Product	value
LOLOMAYA	21/3/2019	First Class	SKU A	1
LOLOMAYA	21/3/2019	First Class	SKU B	1
LOLOMAYA	21/3/2019	First Class	SKU C	0
LOLOMAYA	21/3/2019	Second Class	SKU D	1
LOLOMAYA	21/3/2019	Second Class	SKU E	1
LOLOMAYA	21/3/2019	Second Class	SKU F	1
LULULALA	21/3/2019	First Class	SKU A	0
LULULALA	21/3/2019	First Class	SKU B	0
LULULALA	21/3/2019	First Class	SKU C	1
LULULALA	21/3/2019	Second Class	SKU D	0
LULULALA	21/3/2019	Second Class	SKU E	0
LULULALA	21/3/2019	Second Class	SKU F	0

Result

Transaction_Date	Outlet	Total First Class	SKU A	SKU B	SKU C	Total Second Class	SKU D	SKU E	SKU F
21/3/2019	LOLOMAYA	2	1	1	0	3	1	1	1
21/3/2019	LULULALA	1	0	0	1	0	0	0	0

topic pivot table with dynamic calculation in Developer

pivot table with dynamic calculation