cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pcastro Regular Visitor
Regular Visitor

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 NameAccount numberTransaction Id Debit Amount Country
AA12311 $                       5.00usa
AA12312 $                       5.00Uk
AA12313 $                       6.00Uk
AB12414 $                       7.00Uk
AB12415 $                       8.00Uk
AB12416 $                       9.00Uk
AD12617 $                    10.00Uk
AE12718 $                       1.00Uk

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

Hi @pcastro

 

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 ] )
)

1.png

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

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

Hi @pcastro

 

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 ] )
)

1.png

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.