cancel
Showing results for
Did you mean:
Highlighted
Anonymous
Not applicable

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

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

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Super User

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

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

Proud to be a Datanaut!

Community Support Team

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

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.