cancel
Showing results for
Did you mean:
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
Highlighted
Super Contributor

## 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.

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Highlighted
Super Contributor

## 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.

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 47 members 830 guests
Recent signins: