topic Re: Calculation Involving Duplicates in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3275196#M121487 <P>The Machine and Batch columns are required to make this work.</P> Thu, 08 Jun 2023 18:07:33 GMT lbendlin 2023-06-08T18:07:33Z Calculation Involving Duplicates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3270411#M121193 <P>Without deleting duplicates, how do I write a formula to calculate the total scrap percentage by date?</P><P>&nbsp;</P><P>Scrap% = (Machine Scrap/(Machine Scrap + Good Quantity)) * 100</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Production Day</TD><TD>Machine Scrap</TD><TD>Good Quantity</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>33103</TD><TD>734164</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>33103</TD><TD>734164</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>33103</TD><TD>734164</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>33103</TD><TD>734164</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>33103</TD><TD>734164</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>33103</TD><TD>734164</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>33103</TD><TD>734164</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>33103</TD><TD>734164</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>33103</TD><TD>734164</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>33103</TD><TD>734164</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>33103</TD><TD>734164</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>29452</TD><TD>744589</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>29452</TD><TD>744589</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>29452</TD><TD>744589</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>29452</TD><TD>744589</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>29452</TD><TD>744589</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>29452</TD><TD>744589</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>29452</TD><TD>744589</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>29452</TD><TD>744589</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>29452</TD><TD>744589</TD></TR><TR><TD>06/01/2023 12:00:00 AM</TD><TD>29452</TD><TD>744589</TD></TR></TBODY></TABLE> Tue, 06 Jun 2023 12:11:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3270411#M121193 Anonymous 2023-06-06T12:11:12Z Re: Calculation Involving Duplicates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3273680#M121411 <P><img /></P> <P>&nbsp;</P> Thu, 08 Jun 2023 01:30:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3273680#M121411 lbendlin 2023-06-08T01:30:47Z Re: Calculation Involving Duplicates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3274575#M121457 <P>It's my fault I wasn't clear with what I was trying to ask. What I want to do is use the first instances of the scrap and the good, but I think that I will have to create a new column to flag first instances.</P> Thu, 08 Jun 2023 11:58:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3274575#M121457 Anonymous 2023-06-08T11:58:02Z Re: Calculation Involving Duplicates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3274584#M121459 <P>Not necessarily. If you do a Table.Distinct in Power Query across only one column it will result in the "first"&nbsp; column being grabbed and everything else being dropped.</P> <P>&nbsp;</P> <P>If you want to do this in DAX you can abuse TOPN(1, ) in a similar way but it will be even less deterministic.</P> <P>&nbsp;</P> <P><BR />Please show the expected outcome based on the sample data you provided.</P> Thu, 08 Jun 2023 12:02:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3274584#M121459 lbendlin 2023-06-08T12:02:58Z Re: Calculation Involving Duplicates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3274605#M121460 <P>Here is a better representation of the table that I am trying to use. This information is for one machine, but there are multiple machines.</P><P>I want to be able to filter the Scrap percentage based on: Machine, Work Order, Material, Batch, and/or Production Day.</P><P>Also, I want to determine the percentage of scrap that is dependent on the Rsn Code.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Machine</TD><TD>Work Order</TD><TD>Material</TD><TD>Batch</TD><TD>Crew</TD><TD>Production Day</TD><TD>&nbsp;Rsn Code</TD><TD>Machine Scrap</TD><TD>Scrap Qty</TD><TD>Good Qty</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>&nbsp;xxx1</TD><TD>33103</TD><TD>11241</TD><TD>734164</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>&nbsp;xxx2</TD><TD>33103</TD><TD>2129</TD><TD>734164</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>&nbsp;xxx3</TD><TD>33103</TD><TD>3586</TD><TD>734164</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>&nbsp;xxx4</TD><TD>33103</TD><TD>3507</TD><TD>734164</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>&nbsp;xxx5</TD><TD>33103</TD><TD>1253</TD><TD>734164</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>&nbsp;xxx1</TD><TD>29452</TD><TD>5127</TD><TD>744589</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>&nbsp;xxx2</TD><TD>29452</TD><TD>1376</TD><TD>744589</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>&nbsp;xxx3</TD><TD>29452</TD><TD>3397</TD><TD>744589</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>&nbsp;xxx4</TD><TD>29452</TD><TD>6295</TD><TD>744589</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>&nbsp;xxx5</TD><TD>29452</TD><TD>692</TD><TD>744589</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>&nbsp;xxx1</TD><TD>31577</TD><TD>11671</TD><TD>819528</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>&nbsp;xxx2</TD><TD>31577</TD><TD>698</TD><TD>819528</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>&nbsp;xxx3</TD><TD>31577</TD><TD>4532</TD><TD>819528</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>&nbsp;xxx4</TD><TD>31577</TD><TD>2442</TD><TD>819528</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>&nbsp;xxx5</TD><TD>31577</TD><TD>156</TD><TD>819528</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>&nbsp;xxx1</TD><TD>37337</TD><TD>5668</TD><TD>422891</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>&nbsp;xxx2</TD><TD>37337</TD><TD>2775</TD><TD>422891</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>&nbsp;xxx3</TD><TD>37337</TD><TD>3861</TD><TD>422891</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>&nbsp;xxx4</TD><TD>37337</TD><TD>70</TD><TD>422891</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>&nbsp;xxx5</TD><TD>37337</TD><TD>37</TD><TD>422891</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>&nbsp;xxx1</TD><TD>22584</TD><TD>5435</TD><TD>814593</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>&nbsp;xxx2</TD><TD>22584</TD><TD>2470</TD><TD>814593</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>&nbsp;xxx3</TD><TD>22584</TD><TD>1751</TD><TD>814593</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>&nbsp;xxx4</TD><TD>22584</TD><TD>5103</TD><TD>814593</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>&nbsp;xxx5</TD><TD>22584</TD><TD>343</TD><TD>814593</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>&nbsp;xxx1</TD><TD>27079</TD><TD>15299</TD><TD>981785</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>&nbsp;xxx2</TD><TD>27079</TD><TD>1036</TD><TD>981785</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>&nbsp;xxx3</TD><TD>27079</TD><TD>590</TD><TD>981785</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>&nbsp;xxx4</TD><TD>27079</TD><TD>312</TD><TD>981785</TD></TR><TR><TD>&nbsp;xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>&nbsp;xxx5</TD><TD>27079</TD><TD>110</TD><TD>981785</TD></TR></TBODY></TABLE><P>&nbsp;</P> Thu, 08 Jun 2023 12:26:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3274605#M121460 Anonymous 2023-06-08T12:26:49Z Re: Calculation Involving Duplicates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3274698#M121467 <P><BR />Please show the expected outcome based on the latest sample data you provided.</P> Thu, 08 Jun 2023 13:10:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3274698#M121467 lbendlin 2023-06-08T13:10:21Z Re: Calculation Involving Duplicates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3275118#M121482 <P>I hope this explains what I am looking for. Keep in mind that I have over a million rows of data and they are all in seperate files.</P><TABLE><TBODY><TR><TD>Machine</TD><TD>Work Order</TD><TD>Material</TD><TD>Batch</TD><TD>Production Day</TD><TD>Rsn Code</TD><TD>Machine Scrap</TD><TD>Rsn Scrap Qty</TD><TD>Good Qty</TD><TD>Total Scrap</TD><TD>Rsn Code Scrap</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>xxx1</TD><TD>33103</TD><TD>11241</TD><TD>734164</TD><TD>0.043144042</TD><TD>&nbsp;0.015080393</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>xxx2</TD><TD>33103</TD><TD>2129</TD><TD>734164</TD><TD>&nbsp;</TD><TD>0.002891512</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>xxx3</TD><TD>33103</TD><TD>3586</TD><TD>734164</TD><TD>&nbsp;</TD><TD>0.004860725</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>xxx4</TD><TD>33103</TD><TD>3507</TD><TD>734164</TD><TD>&nbsp;</TD><TD>0.004754152</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>xxx5</TD><TD>33103</TD><TD>1253</TD><TD>734164</TD><TD>&nbsp;</TD><TD>0.001703795</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>xxx1</TD><TD>29452</TD><TD>5127</TD><TD>744589</TD><TD>0.038049664</TD><TD>&nbsp;0.00683859</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>xxx2</TD><TD>29452</TD><TD>1376</TD><TD>744589</TD><TD>&nbsp;</TD><TD>0.001844591</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>xxx3</TD><TD>29452</TD><TD>3397</TD><TD>744589</TD><TD>&nbsp;</TD><TD>0.004541529</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>xxx4</TD><TD>29452</TD><TD>6295</TD><TD>744589</TD><TD>&nbsp;</TD><TD>0.008383452</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/01/2023 12:00:00 AM</TD><TD>xxx5</TD><TD>29452</TD><TD>692</TD><TD>744589</TD><TD>&nbsp;</TD><TD>0.000928509</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>xxx1</TD><TD>31577</TD><TD>11671</TD><TD>819528</TD><TD>0.03710118</TD><TD>&nbsp;0.014041162</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>xxx2</TD><TD>31577</TD><TD>698</TD><TD>819528</TD><TD>&nbsp;</TD><TD>0.000850985</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>xxx3</TD><TD>31577</TD><TD>4532</TD><TD>819528</TD><TD>&nbsp;</TD><TD>0.0054996</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>xxx4</TD><TD>31577</TD><TD>2442</TD><TD>819528</TD><TD>&nbsp;</TD><TD>0.002970911</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>xxx5</TD><TD>31577</TD><TD>156</TD><TD>819528</TD><TD>&nbsp;</TD><TD>0.000190317</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>xxx1</TD><TD>37337</TD><TD>5668</TD><TD>422891</TD><TD>0.08112718</TD><TD>&nbsp;0.013225717</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>xxx2</TD><TD>37337</TD><TD>2775</TD><TD>422891</TD><TD>&nbsp;</TD><TD>0.006519196</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>xxx3</TD><TD>37337</TD><TD>3861</TD><TD>422891</TD><TD>&nbsp;</TD><TD>0.009047409</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>xxx4</TD><TD>37337</TD><TD>70</TD><TD>422891</TD><TD>&nbsp;</TD><TD>0.0001655</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/02/2023 12:00:00 AM</TD><TD>xxx5</TD><TD>37337</TD><TD>37</TD><TD>422891</TD><TD>&nbsp;</TD><TD>8.74853E-05</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>xxx1</TD><TD>22584</TD><TD>5435</TD><TD>814593</TD><TD>0.026976374</TD><TD>&nbsp;0.006627822</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>xxx2</TD><TD>22584</TD><TD>2470</TD><TD>814593</TD><TD>&nbsp;</TD><TD>0.003023023</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>xxx3</TD><TD>22584</TD><TD>1751</TD><TD>814593</TD><TD>&nbsp;</TD><TD>0.002144929</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>xxx4</TD><TD>22584</TD><TD>5103</TD><TD>814593</TD><TD>&nbsp;</TD><TD>0.006225479</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>xxx5</TD><TD>22584</TD><TD>343</TD><TD>814593</TD><TD>&nbsp;</TD><TD>0.000420892</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>xxx1</TD><TD>27079</TD><TD>15299</TD><TD>981785</TD><TD>0.026841081</TD><TD>&nbsp;0.015343742</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>xxx2</TD><TD>27079</TD><TD>1036</TD><TD>981785</TD><TD>&nbsp;</TD><TD>0.001054109</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>xxx3</TD><TD>27079</TD><TD>590</TD><TD>981785</TD><TD>&nbsp;</TD><TD>0.000600585</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>xxx4</TD><TD>27079</TD><TD>312</TD><TD>981785</TD><TD>&nbsp;</TD><TD>0.000317688</TD></TR><TR><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>xxxx</TD><TD>06/03/2023 12:00:00 AM</TD><TD>xxx5</TD><TD>27079</TD><TD>110</TD><TD>981785</TD><TD>&nbsp;</TD><TD>0.000112028</TD></TR></TBODY></TABLE> Thu, 08 Jun 2023 17:17:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3275118#M121482 Anonymous 2023-06-08T17:17:15Z Re: Calculation Involving Duplicates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3275196#M121487 <P>The Machine and Batch columns are required to make this work.</P> Thu, 08 Jun 2023 18:07:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3275196#M121487 lbendlin 2023-06-08T18:07:33Z Re: Calculation Involving Duplicates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3276172#M121537 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;,</P> <P>&nbsp;</P> <P>I suggest you to create two calcualted columns.</P> <LI-CODE lang="markup">Total Scrap = IF('Table'[Rsn Code] = "xxx1",DIVIDE('Table'[Machine Scrap],'Table'[Machine Scrap] + 'Table'[Good Qty]),BLANK())</LI-CODE><LI-CODE lang="markup">Rsn Code Scrap = DIVIDE('Table'[Rsn Scrap Qty],'Table'[Rsn Scrap Qty] + 'Table'[Good Qty])</LI-CODE> <P>Result is as below.</P> <P><img /></P> <P>&nbsp;</P> <P>Best Regards,<BR />Rico Zhou</P> <P>&nbsp;</P> <P>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> Fri, 09 Jun 2023 08:22:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3276172#M121537 Anonymous 2023-06-09T08:22:30Z Re: Calculation Involving Duplicates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3276535#M121548 <P>Two issues with this, the first issue is that I have hundreds of different Rsn Codes, and the second issue is that if I want the total percent for Rsn Code xxx1 it will take an average of percentages and I do not want that.</P><P>&nbsp;</P><P>I want to be able to get total percent for any machine and any rsn code. The total percent per machine will be Scrap% = Machine Scrap / (Machine Scrap + Good Qty) and the rsn scrap will be RsnScrap% = Rsn Scrap Qty / (Rsn Scrap Qty + Good Qty). I need to make it so that I can filter the total scrap percent by production day and filter rsn code scrap by rsn code.</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 09 Jun 2023 12:12:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculation-Involving-Duplicates/m-p/3276535#M121548 Anonymous 2023-06-09T12:12:28Z