How to Select rows that has same value for certain columns, and different value for one column

[Anonymous]

Hello !

I am in a trouble finding a calculated column or measure that Select every rows that has the same value for the 3 columns Bank account, info 1 & info 2 AND when the Supplier is different (it shouldn't happen, thats why I want to detect these anomalies). To make it more clear, here is an example of what I should have with my measure:

Supplier	Bank account	info 1	info 2
A	1000	France	Energy
B	1000	France	Energy
C	1000	China	Oil
A	1000	France	Gaz

The query should return these rows because these 2 suppliers have the same bank account number and same informations (this is an anomaly):

Supplier	Bank account	info 1	info2
A	1000	France	Energy
B	1000	France	Energy

[Jihwan_Kim]

Flag CC =
IF (
COUNTROWS (
FILTER (
Info,
Info[Supplier] <> EARLIER ( Info[Supplier] )
&& Info[Bank account] = EARLIER ( Info[Bank account] )
&& Info[info 1] = EARLIER ( Info[info 1] )
&& Info[info 2] = EARLIER ( Info[info 2] )
)
) >= 1,
1,
BLANK ()
)

https://www.dropbox.com/s/9cqlb3qbhp3pfxp/basbas.pbix?dl=0 

[Anonymous]

Hello @Jihwan_Kim 

I have an issue with this query when I have more than around 5000 rows, it takes too much time and it ends up with a "Memory error, try again when you have more memory available".

Do you know how can I solve this problem ?

Thank you !

[Anonymous]

Thank you it works,

I have another question, do you know how to do the contrary, like one supplier has several lines that aren't composed of the same informations ?
Here it would show the two lines about supplier A:

Supplier	Bank account	info 1	info 2
A	1000	France	Energy
A	1000	France	Gaz