Help with measure

[Coryanthony]

I want to filter out debit and credits from table, either in power query or dax formula (both if all possible).

Any suggestions? If the transaction was refunded entirely (Yellow highlight), i want to filter it off the report. If it was a partial refund (green highlight) or not refunded, i want to see it. 

Please help.

[amitchandak]

@Coryanthony , create a new column and use that

new col =

var _cnt = countx(filter(Table, [employee ID] = earlier([employee ID] ) && [vendor] = earlier([vendor] ) && [Transaction Amount] = -1* earlier([Transaction Amount] )), [Transaction Amount])

Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s

return if(isbalnk(_cnt), 0,1)