topic Caculate summary from other category in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Caculate-summary-from-other-category/m-p/680756#M431 <P>Hi, can anyone help me to create dax formular that summary total Sale from product "A" but show data in row of product "B" like show in column "Dummy" but in row product "A" show 0 in column Dummy.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Product</TD><TD>Total Sale</TD><TD>Dummy</TD></TR><TR><TD>A</TD><TD>11</TD><TD>&nbsp;</TD></TR><TR><TD>B</TD><TD>29</TD><TD>11</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Below is raw data</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD><FONT face="Calibri">Product</FONT></TD><TD><FONT face="Calibri">Sale</FONT></TD></TR><TR><TD><FONT face="Calibri">A</FONT></TD><TD><FONT face="Calibri">3</FONT></TD></TR><TR><TD><FONT face="Calibri">A</FONT></TD><TD><FONT face="Calibri">2</FONT></TD></TR><TR><TD><FONT face="Calibri">B</FONT></TD><TD><FONT face="Calibri">5</FONT></TD></TR><TR><TD><FONT face="Calibri">B</FONT></TD><TD><FONT face="Calibri">7</FONT></TD></TR><TR><TD><FONT face="Calibri">A</FONT></TD><TD><FONT face="Calibri">3</FONT></TD></TR><TR><TD><FONT face="Calibri">B</FONT></TD><TD><FONT face="Calibri">7</FONT></TD></TR><TR><TD><FONT face="Calibri">A</FONT></TD><TD><FONT face="Calibri">3</FONT></TD></TR><TR><TD><FONT face="Calibri">B</FONT></TD><TD><FONT face="Calibri">7</FONT></TD></TR><TR><TD><FONT face="Calibri">B</FONT></TD><TD><FONT face="Calibri">2</FONT></TD></TR><TR><TD><FONT face="Calibri">B</FONT></TD><TD><P><FONT face="Calibri">1</FONT></P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you so much.</P> Tue, 30 Apr 2019 09:59:22 GMT ttyp 2019-04-30T09:59:22Z Caculate summary from other category https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Caculate-summary-from-other-category/m-p/680756#M431 <P>Hi, can anyone help me to create dax formular that summary total Sale from product "A" but show data in row of product "B" like show in column "Dummy" but in row product "A" show 0 in column Dummy.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Product</TD><TD>Total Sale</TD><TD>Dummy</TD></TR><TR><TD>A</TD><TD>11</TD><TD>&nbsp;</TD></TR><TR><TD>B</TD><TD>29</TD><TD>11</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Below is raw data</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD><FONT face="Calibri">Product</FONT></TD><TD><FONT face="Calibri">Sale</FONT></TD></TR><TR><TD><FONT face="Calibri">A</FONT></TD><TD><FONT face="Calibri">3</FONT></TD></TR><TR><TD><FONT face="Calibri">A</FONT></TD><TD><FONT face="Calibri">2</FONT></TD></TR><TR><TD><FONT face="Calibri">B</FONT></TD><TD><FONT face="Calibri">5</FONT></TD></TR><TR><TD><FONT face="Calibri">B</FONT></TD><TD><FONT face="Calibri">7</FONT></TD></TR><TR><TD><FONT face="Calibri">A</FONT></TD><TD><FONT face="Calibri">3</FONT></TD></TR><TR><TD><FONT face="Calibri">B</FONT></TD><TD><FONT face="Calibri">7</FONT></TD></TR><TR><TD><FONT face="Calibri">A</FONT></TD><TD><FONT face="Calibri">3</FONT></TD></TR><TR><TD><FONT face="Calibri">B</FONT></TD><TD><FONT face="Calibri">7</FONT></TD></TR><TR><TD><FONT face="Calibri">B</FONT></TD><TD><FONT face="Calibri">2</FONT></TD></TR><TR><TD><FONT face="Calibri">B</FONT></TD><TD><P><FONT face="Calibri">1</FONT></P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you so much.</P> Tue, 30 Apr 2019 09:59:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Caculate-summary-from-other-category/m-p/680756#M431 ttyp 2019-04-30T09:59:22Z