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]))
HoangHugo
Solution Specialist
Solution SpecialistHi,
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]))