topic Re: distinct sum in DAX Commands and Tips

topic Re: distinct sum in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-sum/m-p/1060193#M14716 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="145323" data-lia-user-login="Mniknejad" class="lia-mention lia-mention-user">Mniknejad</a> ,</P><P> </P><P>This is working fine with value as sum.</P><P> </P><P><img /><img /></P><P> </P><P> </P><P>Regards,</P><P>Harsh Nathani</P> Thu, 30 Apr 2020 23:18:20 GMT Anonymous 2020-04-30T23:18:20Z distinct sum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-sum/m-p/1054803#M14519 <P>I have two table one is a dim item like this </P><P> </P><TABLE><TBODY><TR><TD>ItemKEY</TD><TD>ItemNumber</TD><TD>ProductName</TD><TD>ColorDescription</TD><TD>Size</TD><TD>ORDERNUMBER</TD><TD>ID</TD></TR><TR><TD>46-07-2XL</TD><TD>46</TD><TD>ITEMA</TD><TD>Blue</TD><TD>2XL</TD><TD>8</TD><TD>87799</TD></TR><TR><TD>46-07-2XS</TD><TD>46</TD><TD>ITEMA</TD><TD>Blue</TD><TD>2XS</TD><TD>2</TD><TD>87775</TD></TR><TR><TD>46-07-3XL</TD><TD>46</TD><TD>ITEMA</TD><TD>Blue</TD><TD>3XL</TD><TD>9</TD><TD>87802</TD></TR><TR><TD>46-07-L</TD><TD>46</TD><TD>ITEMA</TD><TD>Blue</TD><TD>L</TD><TD>6</TD><TD>87791</TD></TR><TR><TD>46-07-M</TD><TD>46</TD><TD>ITEMA</TD><TD>Blue</TD><TD>M</TD><TD>5</TD><TD>87787</TD></TR><TR><TD>46-07-S</TD><TD>46</TD><TD>ITEMA</TD><TD>Blue</TD><TD>S</TD><TD>4</TD><TD>87783</TD></TR><TR><TD>46-07-XL</TD><TD>46</TD><TD>ITEMA</TD><TD>Blue</TD><TD>XL</TD><TD>7</TD><TD>87795</TD></TR><TR><TD>46-07-XS</TD><TD>46</TD><TD>ITEMA</TD><TD>Blue</TD><TD>XS</TD><TD>3</TD><TD>87779</TD></TR><TR><TD>46-11-2XL</TD><TD>46</TD><TD>ITEMA</TD><TD>Red</TD><TD>2XL</TD><TD>8</TD><TD>87671</TD></TR><TR><TD>46-11-2XS</TD><TD>46</TD><TD>ITEMA</TD><TD>Red</TD><TD>2XS</TD><TD>2</TD><TD>87646</TD></TR><TR><TD>46-11-3XL</TD><TD>46</TD><TD>ITEMA</TD><TD>Red</TD><TD>3XL</TD><TD>9</TD><TD>87675</TD></TR><TR><TD>46-11-L</TD><TD>46</TD><TD>ITEMA</TD><TD>Red</TD><TD>L</TD><TD>6</TD><TD>87663</TD></TR><TR><TD>46-11-M</TD><TD>46</TD><TD>ITEMA</TD><TD>Red</TD><TD>M</TD><TD>5</TD><TD>87659</TD></TR><TR><TD>46-11-S</TD><TD>46</TD><TD>ITEMA</TD><TD>Red</TD><TD>S</TD><TD>4</TD><TD>87654</TD></TR><TR><TD>46-11-XL</TD><TD>46</TD><TD>ITEMA</TD><TD>Red</TD><TD>XL</TD><TD>7</TD><TD>87667</TD></TR><TR><TD>46-11-XS</TD><TD>46</TD><TD>ITEMA</TD><TD>Red</TD><TD>XS</TD><TD>3</TD><TD>87650</TD></TR></TBODY></TABLE><P> </P><P>another is fact like this </P><TABLE><TBODY><TR><TD>ItemKey  </TD><TD>color</TD><TD>ItemID</TD><TD>Size</TD><TD>InventoryDate</TD><TD>amount</TD></TR><TR><TD>46-11-2XS</TD><TD>11</TD><TD>46</TD><TD>2XS</TD><TD>2020-04-20</TD><TD>0</TD></TR><TR><TD>46-11-2XS</TD><TD>11</TD><TD>46</TD><TD>2XS</TD><TD>2020-04-21</TD><TD>0</TD></TR><TR><TD>46-11-S</TD><TD>11</TD><TD>46</TD><TD>S</TD><TD>2020-04-20</TD><TD>2</TD></TR><TR><TD>46-11-S</TD><TD>11</TD><TD>46</TD><TD>S</TD><TD>2020-04-21</TD><TD>1</TD></TR><TR><TD>46-11-2XS</TD><TD>11</TD><TD>46</TD><TD>2XS</TD><TD>2020-04-20</TD><TD>0</TD></TR><TR><TD>46-11-2XS</TD><TD>11</TD><TD>46</TD><TD>2XS</TD><TD>2020-04-21</TD><TD>0</TD></TR><TR><TD>46-11-3XL</TD><TD>11</TD><TD>46</TD><TD>3XL</TD><TD>2020-04-20</TD><TD>1</TD></TR><TR><TD>46-11-3XL</TD><TD>11</TD><TD>46</TD><TD>3XL</TD><TD>2020-04-21</TD><TD>1</TD></TR><TR><TD>46-07-S</TD><TD>7</TD><TD>46</TD><TD>S</TD><TD>2020-04-20</TD><TD>0</TD></TR><TR><TD>46-07-S</TD><TD>7</TD><TD>46</TD><TD>S</TD><TD>2020-04-21</TD><TD>3</TD></TR><TR><TD>46-11-3XL</TD><TD>11</TD><TD>46</TD><TD>3XL</TD><TD>2020-04-20</TD><TD>1</TD></TR><TR><TD>46-11-3XL</TD><TD>11</TD><TD>46</TD><TD>3XL</TD><TD>2020-04-21</TD><TD>1</TD></TR><TR><TD>46-11-XL</TD><TD>11</TD><TD>46</TD><TD>XL</TD><TD>2020-04-20</TD><TD>1</TD></TR><TR><TD>46-11-XL</TD><TD>11</TD><TD>46</TD><TD>XL</TD><TD>2020-04-21</TD><TD>1</TD></TR><TR><TD>46-11-M</TD><TD>11</TD><TD>46</TD><TD>M</TD><TD>2020-04-20</TD><TD>13</TD></TR><TR><TD>46-11-M</TD><TD>11</TD><TD>46</TD><TD>M</TD><TD>2020-04-21</TD><TD>1</TD></TR><TR><TD>46-7-XS</TD><TD>7</TD><TD>46</TD><TD>XS</TD><TD>2020-04-20</TD><TD>1</TD></TR><TR><TD>46-07-XS</TD><TD>7</TD><TD>46</TD><TD>XS</TD><TD>2020-04-21</TD><TD>1</TD></TR></TBODY></TABLE><P> </P><P>these are joined on ItemKey and Itemkey is unique base on itemid,color and size but when I wanted to show  total Sum like this </P><TABLE><TBODY><TR><TD>NAME</TD><TD>Total amount </TD></TR><TR><TD>ItemA</TD><TD>665</TD></TR></TBODY></TABLE><P>this is what I can get </P><TABLE><TBODY><TR><TD>NAME</TD><TD>Total amount </TD></TR><TR><TD>ItemA</TD><TD>10</TD></TR><TR><TD>ItemA</TD><TD>235</TD></TR><TR><TD>ItemA</TD><TD>10</TD></TR><TR><TD>ItemA</TD><TD>10</TD></TR><TR><TD>ItemA</TD><TD>25</TD></TR><TR><TD>ItemA</TD><TD>5</TD></TR><TR><TD>ItemA</TD><TD>15</TD></TR><TR><TD>ItemA</TD><TD>90</TD></TR><TR><TD>ItemA</TD><TD>125</TD></TR><TR><TD>ItemA</TD><TD>25</TD></TR><TR><TD>ItemA</TD><TD>100</TD></TR><TR><TD>ItemA</TD><TD>5</TD></TR><TR><TD>ItemA</TD><TD>5</TD></TR><TR><TD>ItemA</TD><TD>5</TD></TR></TBODY></TABLE><P>Do you know what 's my issue ?</P> Tue, 28 Apr 2020 22:31:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-sum/m-p/1054803#M14519 Mniknejad 2020-04-28T22:31:04Z Re: distinct sum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-sum/m-p/1055644#M14546 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="145323" data-lia-user-login="Mniknejad" class="lia-mention lia-mention-user">Mniknejad</a> </P><P> </P><P>It seems like your default summarization is "<STRONG>Don't summarize</STRONG>". You have to choose <STRONG>Sum</STRONG>.</P><P> </P><P>Please refer to this link <A href="https://docs.microsoft.com/en-us/power-bi/service-aggregates" target="_blank">https://docs.microsoft.com/en-us/power-bi/service-aggregates</A></P><P> </P><P><BR /><BR /><STRONG>Did I answer your question? Mark my post as a solution!<BR />Appreciate with a kudos </STRONG><span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P> </P> Wed, 29 Apr 2020 07:47:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-sum/m-p/1055644#M14546 nandukrishnavs 2020-04-29T07:47:04Z Re: distinct sum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-sum/m-p/1056463#M14574 <P>it's sum</P> Wed, 29 Apr 2020 12:42:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-sum/m-p/1056463#M14574 Mniknejad 2020-04-29T12:42:28Z Re: distinct sum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-sum/m-p/1060193#M14716 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="145323" data-lia-user-login="Mniknejad" class="lia-mention lia-mention-user">Mniknejad</a> ,</P><P> </P><P>This is working fine with value as sum.</P><P> </P><P><img /><img /></P><P> </P><P> </P><P>Regards,</P><P>Harsh Nathani</P> Thu, 30 Apr 2020 23:18:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-sum/m-p/1060193#M14716 Anonymous 2020-04-30T23:18:20Z Re: distinct sum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-sum/m-p/1298868#M22459 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="145323" data-lia-user-login="Mniknejad" class="lia-mention lia-mention-user">Mniknejad</a> ,</P> <P> </P> <P>Did the solution work for you.</P> <P> </P> <P>Please mark as solution for other community members to benefit.</P> <P> </P> <P>Regards,<BR />Harsh Nathani<BR /><STRONG>Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)</STRONG></P> Sun, 16 Aug 2020 13:31:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/distinct-sum/m-p/1298868#M22459 Anonymous 2020-08-16T13:31:17Z