How to sum value only once based on two other columns

[Anonymous]

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

[PaulOlding · Accepted solution]

Hi @Anonymous 

This should do the trick

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

[Anonymous]

Seems to work, thanks!