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
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

I created a sample pbix file(see the attachment), please check if that is what you want.

If the above one can't help you get the desired result, please provide some sample data in your table 'data'  (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hey Anonymous , thank you for your help.

 

Unfortunately, your solution is the same as mine, and there are rare cases in which filtered rank shows bad values. For example 27_Cat and 6_Cat are wrong (in my file)

 

Please find a link to my pbix file:

https://www.dropbox.com/s/fhbpj7pgragr2g6/Ranking%20test.pbix?dl=0