Forum Discussion
Bmejia
Super User
Super UserIdentify duplicate values with different values
I am trying to identify if a employeed submitted the same expense amount in two different orders or in the same order. I have builded this measure column to filter down in my visual if the same amou...
Hi,
I understand, in filter 1, you look up new orders have same amount, so it should be:
New =COUNTROWS(FILTER(Table1,Table1[orders]<>EARLIER(Table1[orders])&& EARLIER(Table1[Amount])=Table1[Amount]))
BmejiaSuper User
Super UserHoangHugo solution works, but once i implemented with production data which is alot more data, it is taking a long time to load. I had to stopped. is there a more efficient way to get this resolve where it does not take a toll on the data load performance.
HoangHugo
Solution Specialist
Solution SpecialistSure, Microsoft advices EARLIER may take long time. In your case, scanning entire table is required, but I suggest you use SUMMARIZE make a new table to reduce rows that system have to scan