Forum Discussion
Rank Formula Assistance
I am trying to rank companies based on their revenues in my data set. It is a large data set with many rows of data for each company in a year and am looking for their rank based on revenue largest ...
v-jingzhang
Community Support
Community SupportHi Anonymous
It would be more helpful for us to understand your purpose if you could share some dummy data and expected result. When a Rank formula is in a measure in the report or in a calculated column, it may return different results because the context for calculation is different. Also, when you only use ALL in the formula, the category will not be taken into account.
Best Regards,
Community Support Team _ Jing