Find accounts that made the same amount of a transaction more than once.

[Anonymous]

Hello, 

I need to get a count of a specific column, however it is counting the entire row individually giving us a count of 1 for every row because of the distinct values in each row. 

How do we get it to only count only 1 isolated column while ignoring the others? 

Basically we want the debit column (Refer to the table below) to have a count of 2 for $5, and a count of 1 for the others. 

Please know that the account name and debit amount are a part of the criteria. 

In summary, we need to find accounts  that made the same amount of a transaction more than once.

Account Name	Account number	Transaction Id	Debit Amount	Country
AA	123	11	$                       5.00	usa
AA	123	12	$                       5.00	Uk
AA	123	13	$                       6.00	Uk
AB	124	14	$                       7.00	Uk
AB	124	15	$                       8.00	Uk
AB	124	16	$                       9.00	Uk
AD	126	17	$                    10.00	Uk
AE	127	18	$                       1.00	Uk

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may try to create a calculated column or a measure with ALLEXCEPT Function.

Column =
CALCULATE (
    COUNT ( Table3[ Debit Amount ] ),
    ALLEXCEPT ( Table3, Table3[ Debit Amount ] )
)

Regards,

Cherie

[Greg_Deckler]

So typically you would use something like SUMMARIZE to do that.