Forum Discussion
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...
Hi Anonymous , try to use HASONEFILTER, it worked for me.
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.