RANKX gives another value with filter

I have data containing, among other things, dates when a sale has taken place, the counterparty and the value. I have 2 (dropdown) sliders on my page, one to select the counterparty of which i want t...