https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-composition-ratio-in-powerBI-2/m-p/2740087#M84172 <P>Hello,</P><P>I want to display output Matrix B from data table A.</P><P>Too difficult for me.</P><P>Please Help me !</P><P>&nbsp;</P><P><STRONG>data table A</STRONG></P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>DIV</TD><TD>Att</TD><TD>value</TD></TR><TR><TD>2020/04</TD><TD>Net Sales</TD><TD>Actual</TD><TD>600,000</TD></TR><TR><TD>2020/04</TD><TD>Net Sales</TD><TD>Plan</TD><TD>590,000</TD></TR><TR><TD>2020/04</TD><TD>Cost of Sales</TD><TD>Actual</TD><TD>300,000</TD></TR><TR><TD>2020/04</TD><TD>Cost of Sales</TD><TD>Plan</TD><TD>310,000</TD></TR><TR><TD>2020/04</TD><TD>Gross Profit</TD><TD>Actual</TD><TD>300,000</TD></TR><TR><TD>2020/04</TD><TD>Gross Profit</TD><TD>Plan</TD><TD>280,000</TD></TR><TR><TD>2020/04</TD><TD>SGA expenses</TD><TD>Actual</TD><TD>120,000</TD></TR><TR><TD>2020/04</TD><TD>SGA expenses</TD><TD>Plan</TD><TD>120,000</TD></TR><TR><TD>2020/04</TD><TD>Operating income</TD><TD>Actual</TD><TD>180,000</TD></TR><TR><TD>2020/04</TD><TD>Operating income</TD><TD>Plan</TD><TD>160,000</TD></TR><TR><TD>2020/05</TD><TD>Net Sales</TD><TD>Actual</TD><TD>800,000</TD></TR><TR><TD>2020/05</TD><TD>Net Sales</TD><TD>Plan</TD><TD>810,000</TD></TR><TR><TD>2020/05</TD><TD>Cost of Sales</TD><TD>Actual</TD><TD>390,000</TD></TR><TR><TD>2020/05</TD><TD>Cost of Sales</TD><TD>Plan</TD><TD>400,000</TD></TR><TR><TD>2020/05</TD><TD>Gross Profit</TD><TD>Actual</TD><TD>410,000</TD></TR><TR><TD>2020/05</TD><TD>Gross Profit</TD><TD>Plan</TD><TD>410,000</TD></TR><TR><TD>2020/05</TD><TD>SGA expenses</TD><TD>Actual</TD><TD>125,000</TD></TR><TR><TD>2020/05</TD><TD>SGA expenses</TD><TD>Plan</TD><TD>130,000</TD></TR><TR><TD>2020/05</TD><TD>Operating income</TD><TD>Actual</TD><TD>285,000</TD></TR><TR><TD>2020/05</TD><TD>Operating income</TD><TD>Plan</TD><TD>280,000</TD></TR><TR><TD>2020/06</TD><TD>Net Sales</TD><TD>Actual</TD><TD>500,000</TD></TR><TR><TD>2020/06</TD><TD>Net Sales</TD><TD>Plan</TD><TD>490,000</TD></TR><TR><TD>2020/06</TD><TD>Cost of Sales</TD><TD>Actual</TD><TD>260,000</TD></TR><TR><TD>2020/06</TD><TD>Cost of Sales</TD><TD>Plan</TD><TD>250,000</TD></TR><TR><TD>2020/06</TD><TD>Gross Profit</TD><TD>Actual</TD><TD>240,000</TD></TR><TR><TD>2020/06</TD><TD>Gross Profit</TD><TD>Plan</TD><TD>240,000</TD></TR><TR><TD>2020/06</TD><TD>SGA expenses</TD><TD>Actual</TD><TD>120,000</TD></TR><TR><TD>2020/06</TD><TD>SGA expenses</TD><TD>Plan</TD><TD>130,000</TD></TR><TR><TD>2020/06</TD><TD>Operating income</TD><TD>Actual</TD><TD>120,000</TD></TR><TR><TD>2020/05</TD><TD>Operating income</TD><TD>Plan</TD><TD>110,000</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>output Matrix B<BR /></STRONG>Slicer : Date = 2020/04<STRONG><BR /></STRONG></P><TABLE border="1"><TBODY><TR><TD>　</TD><TD>Plan</TD><TD>&nbsp;</TD><TD>Actual</TD><TD>&nbsp;</TD></TR><TR><TD>　</TD><TD>TTL Value Plan</TD><TD>composition ratio</TD><TD>TTL Value Actual</TD><TD>composition ratio</TD></TR><TR><TD>Net Sales</TD><TD>590,000</TD><TD>100.0%</TD><TD>600,000</TD><TD>100.0%</TD></TR><TR><TD>Cost of Sales</TD><TD>310,000</TD><TD>52.5%</TD><TD>300,000</TD><TD>50.0%</TD></TR><TR><TD>Gross Profit</TD><TD>280,000</TD><TD>47.5%</TD><TD>300,000</TD><TD>50.0%</TD></TR><TR><TD>SGA expenses</TD><TD>120,000</TD><TD>20.3%</TD><TD>120,000</TD><TD>20.0%</TD></TR><TR><TD>Operating income</TD><TD>160,000</TD><TD>27.1%</TD><TD>180,000</TD><TD>30.0%</TD></TR></TBODY></TABLE> Thu, 01 Sep 2022 08:13:20 GMT gaccho_na 2022-09-01T08:13:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-composition-ratio-in-powerBI-2/m-p/2740087#M84172 <P>Hello,</P><P>I want to display output Matrix B from data table A.</P><P>Too difficult for me.</P><P>Please Help me !</P><P>&nbsp;</P><P><STRONG>data table A</STRONG></P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>DIV</TD><TD>Att</TD><TD>value</TD></TR><TR><TD>2020/04</TD><TD>Net Sales</TD><TD>Actual</TD><TD>600,000</TD></TR><TR><TD>2020/04</TD><TD>Net Sales</TD><TD>Plan</TD><TD>590,000</TD></TR><TR><TD>2020/04</TD><TD>Cost of Sales</TD><TD>Actual</TD><TD>300,000</TD></TR><TR><TD>2020/04</TD><TD>Cost of Sales</TD><TD>Plan</TD><TD>310,000</TD></TR><TR><TD>2020/04</TD><TD>Gross Profit</TD><TD>Actual</TD><TD>300,000</TD></TR><TR><TD>2020/04</TD><TD>Gross Profit</TD><TD>Plan</TD><TD>280,000</TD></TR><TR><TD>2020/04</TD><TD>SGA expenses</TD><TD>Actual</TD><TD>120,000</TD></TR><TR><TD>2020/04</TD><TD>SGA expenses</TD><TD>Plan</TD><TD>120,000</TD></TR><TR><TD>2020/04</TD><TD>Operating income</TD><TD>Actual</TD><TD>180,000</TD></TR><TR><TD>2020/04</TD><TD>Operating income</TD><TD>Plan</TD><TD>160,000</TD></TR><TR><TD>2020/05</TD><TD>Net Sales</TD><TD>Actual</TD><TD>800,000</TD></TR><TR><TD>2020/05</TD><TD>Net Sales</TD><TD>Plan</TD><TD>810,000</TD></TR><TR><TD>2020/05</TD><TD>Cost of Sales</TD><TD>Actual</TD><TD>390,000</TD></TR><TR><TD>2020/05</TD><TD>Cost of Sales</TD><TD>Plan</TD><TD>400,000</TD></TR><TR><TD>2020/05</TD><TD>Gross Profit</TD><TD>Actual</TD><TD>410,000</TD></TR><TR><TD>2020/05</TD><TD>Gross Profit</TD><TD>Plan</TD><TD>410,000</TD></TR><TR><TD>2020/05</TD><TD>SGA expenses</TD><TD>Actual</TD><TD>125,000</TD></TR><TR><TD>2020/05</TD><TD>SGA expenses</TD><TD>Plan</TD><TD>130,000</TD></TR><TR><TD>2020/05</TD><TD>Operating income</TD><TD>Actual</TD><TD>285,000</TD></TR><TR><TD>2020/05</TD><TD>Operating income</TD><TD>Plan</TD><TD>280,000</TD></TR><TR><TD>2020/06</TD><TD>Net Sales</TD><TD>Actual</TD><TD>500,000</TD></TR><TR><TD>2020/06</TD><TD>Net Sales</TD><TD>Plan</TD><TD>490,000</TD></TR><TR><TD>2020/06</TD><TD>Cost of Sales</TD><TD>Actual</TD><TD>260,000</TD></TR><TR><TD>2020/06</TD><TD>Cost of Sales</TD><TD>Plan</TD><TD>250,000</TD></TR><TR><TD>2020/06</TD><TD>Gross Profit</TD><TD>Actual</TD><TD>240,000</TD></TR><TR><TD>2020/06</TD><TD>Gross Profit</TD><TD>Plan</TD><TD>240,000</TD></TR><TR><TD>2020/06</TD><TD>SGA expenses</TD><TD>Actual</TD><TD>120,000</TD></TR><TR><TD>2020/06</TD><TD>SGA expenses</TD><TD>Plan</TD><TD>130,000</TD></TR><TR><TD>2020/06</TD><TD>Operating income</TD><TD>Actual</TD><TD>120,000</TD></TR><TR><TD>2020/05</TD><TD>Operating income</TD><TD>Plan</TD><TD>110,000</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>output Matrix B<BR /></STRONG>Slicer : Date = 2020/04<STRONG><BR /></STRONG></P><TABLE border="1"><TBODY><TR><TD>　</TD><TD>Plan</TD><TD>&nbsp;</TD><TD>Actual</TD><TD>&nbsp;</TD></TR><TR><TD>　</TD><TD>TTL Value Plan</TD><TD>composition ratio</TD><TD>TTL Value Actual</TD><TD>composition ratio</TD></TR><TR><TD>Net Sales</TD><TD>590,000</TD><TD>100.0%</TD><TD>600,000</TD><TD>100.0%</TD></TR><TR><TD>Cost of Sales</TD><TD>310,000</TD><TD>52.5%</TD><TD>300,000</TD><TD>50.0%</TD></TR><TR><TD>Gross Profit</TD><TD>280,000</TD><TD>47.5%</TD><TD>300,000</TD><TD>50.0%</TD></TR><TR><TD>SGA expenses</TD><TD>120,000</TD><TD>20.3%</TD><TD>120,000</TD><TD>20.0%</TD></TR><TR><TD>Operating income</TD><TD>160,000</TD><TD>27.1%</TD><TD>180,000</TD><TD>30.0%</TD></TR></TBODY></TABLE> Thu, 01 Sep 2022 08:13:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-composition-ratio-in-powerBI-2/m-p/2740087#M84172 gaccho_na 2022-09-01T08:13:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-composition-ratio-in-powerBI-2/m-p/2740472#M84210 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="434365" data-lia-user-login="gaccho_na" class="lia-mention lia-mention-user">gaccho_na</a> , You need two measures</P> <P>&nbsp;</P> <P>M1 = sum(Data[Value])<BR /><BR />% = Divide(sum(Data[Value]), calculate(sum(Data[Value]), filter(allselected(Data[DIV]), Data[DIV] = "Net Sales" )))</P> <P>&nbsp;</P> <P>Please find the attached file after signature</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 01 Sep 2022 10:06:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-composition-ratio-in-powerBI-2/m-p/2740472#M84210 amitchandak 2022-09-01T10:06:37Z