Forum Discussion
Solved
Identify 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]))
Thanks Hoang, I just added another earlier statatement to breakout the data by all the employees in my table as my example only included one employee.
New =
COUNTROWS(
FILTER(Table1,
Table1[orders]<>EARLIER(Table1[orders])
&& EARLIER(Table1[Amount])=Table1[Amount])
&& EARLIER(Table1[Employee])=Table1[Employee]))