Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 !
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 |