Forum Discussion
Solved
Customer with multiple accounts
I have a customer table with multiple columns, the main columns are: SSN, AccountNumber, FirstName, LastName, MI, LastTransactionDate. SSN is the unique identifier, because last name could change d...
I think you are looking at the grand total, the same as what is done is this issue
SUMX ( DISTINCT ( Table1[SSN] ), INT ( CALCULATE ( COUNT ( Table1[Account No] ) ) >= 1 ) )
I am looking for how many ssn that have more than one accountnumber. is that what the formula for?
I think you are looking at the grand total, the same as what is done is this issue
SUMX ( DISTINCT ( Table1[SSN] ), INT ( CALCULATE ( COUNT ( Table1[Account No] ) ) >= 1 ) )