topic How to sum value only once based on two other columns in DAX Commands and Tips

How to sum value only once based on two other columns

Anonymous — Fri, 19 May 2023 15:44:19 GMT

Let's say I have a column called First Name and column called Last Name. The name combo always means the same person, but it can appear on table multiple times. There's also the Account column, which is always the same for the name combo. How would I create a measure that sums the account while calculating the same name combo's account only once?

First Name	Last Name	Account
Billy	Curtis	30 000
Billy	Johnson	15 000
Rachel	Thompson	20 000
Rachel	Thompson	20 000
Billy	Curtis	30 000
		Total: 65 000

Re: How to sum value only once based on two other columns

PaulOlding — Fri, 19 May 2023 16:00:16 GMT

Hi Anonymous

This should do the trick

Account Total = SUMX( SUMMARIZE('Table', 'Table'[First Name], 'Table'[Last Name], 'Table'[Account]), 'Table'[Account] )

Re: How to sum value only once based on two other columns

Anonymous — Fri, 19 May 2023 16:26:16 GMT

Seems to work, thanks!