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 to see the ranking based on total value of the sales and one to select the year for which I want to see the ranking. i also have some page level filters to block out some products which which i dont want in the total sales. I have the following measure to derive the ranking:
ranking = rankx(ALL(SCD_data[Ctp]),CALCULATE(sum(SCD_data[MW_EUR])))
When i just select the year and dont select any counterparty in the dropdown slider i get the correct ranking. But if i select a counterparty in the dropdown the incorrect ranking is presented. What am I doing wrong?