Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Ranking - problem when filtering only one value

Hi All,   I have a problem with RANKX function. I need to prepare a report in which a user will be able to select one category value, and will see rank in terms of a measure of that value.   I've...
Need Help
amontoulieu's avatar
amontoulieu
Frequent Visitor
3 years ago

Hello Anonymous , I have the same issue, et no way to find out why?
Any progress on this problem?

Thx

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi amontoulieu , unfortunately, I still do not have solution

    • amontoulieu's avatar
      amontoulieu
      Frequent Visitor
      2 years ago

      Hi Anonymous , try to use HASONEFILTER, it worked for me.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hey amontoulieu , thanks for the info but still not working.

        It's fine when there is no filter on dates, but when I change the data range, then the result is different. On the screen below Category 10 should have rank 8, but it shows 3.