Table calculating totals incorrectly

[Roger_McCallen]

I have a table that is calculating row totals correctly, however the columns are not calculating correctly. The measure is taking the total sales in units multiplied by the number of pieces within each item divided by the number of duplicate items in the lookup table.

The issue I have is the lookup table has duplicates of the same item with minor attribute differences over time and I want to have the table aggregate the sales by item instead of showing multiple lines of the same item showing sales.

Here is the formula:

Total Pieces Sold = ([Unit Sales by Week]*('Item Info'[PackCount]))/COUNT('Item Info'[Description])

Any help the community can provide would be much appreciated

[Greg_Deckler · Accepted solution]

@Roger_McCallen First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8