cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Daxter Visitor
Visitor

Identifying duplicates in a column and summarize associated cells from another column

I have a table of transactions with amounts, transaction IDs and customers where several transactions can have the same customer. I would like to identify the duplicates in the customer column, and summarize the amounts associated to each individual customer. From then, I would like to sort these sums in a column, with decreasing sums. Is there any way to make this happen with DAX-formulas?

1 REPLY 1
Super User
Super User

Re: Identifying duplicates in a column and summarize associated cells from another column

Why would you not just use a matrix?