Combining article duplicates with the total of units sold

[Elivanbijnen]

It's amateur hour. Just started.

I have duplicate articles on the left, for which i would like to have the sum of the right column.

Lets say for article 01-0039, I would like to see it only show once, with the sum of the noted units on the right.

So in the case of 01-0039, it would show 01-0039 : 6 

Greetings,

Eli

[jpessoa8 · Accepted solution]

Hi @Elivanbijnen ,

How are you creating that table visual? Drag and drop both fields?

If you want an aggregated value, you should keep the column with the "Article" and replace the other column with a measure that does something like this :

Total = SUM(TableName[ColumnToAddName])

The way you're doing it, PowerBI is not aggregating the second column, it's simply showing all the rows existing in the table.

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudo 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Jorge Pessoa