Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Elivanbijnen
New Member

Combining article duplicates with the total of units sold

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.

 

Elivanbijnen_0-1700821554564.png

 

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

 

1 ACCEPTED SOLUTION
jpessoa8
Continued Contributor
Continued Contributor

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

View solution in original post

1 REPLY 1
jpessoa8
Continued Contributor
Continued Contributor

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors