Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 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?
Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Allselected also doesnt give the right ranking

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Anonymous,

     

    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.