Forum Discussion

Moniek's avatar
Moniek
Icon for Resolver I rankResolver I
3 years ago
Solved

Show only rows with the same value

Hi

I have a table with many transactions including date, amount, description and other columns. Now I want to see only the lines with the same amount? How can solve this?

Thanks

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Moniek , create a new column

     

    cnt = Countx(filter(Table, Table[Amount] = earlier(Table[Amount])) , Table[Amount])

     

    You have filter cnt> 1 in visual

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Moniek , create a new column

     

    cnt = Countx(filter(Table, Table[Amount] = earlier(Table[Amount])) , Table[Amount])

     

    You have filter cnt> 1 in visual