RANKX gives another value with filter

[Kanivan]

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?

[v-yuta-msft]

@Kanivan,

Could you share some sample data and clarify more details about the expected result?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Zubair_Muhammad]

@Kanivan

Try ALLSELECTED instead of ALL in the formula

[Kanivan]

Allselected also doesnt give the right ranking