Forum Discussion
Using rankx and calculate
Hi everyone, So I used rankx in order to rank sales by client. My client asked me to show TOP 30 clients by sales, I did that filtering the object to show those 30. But my client also wants me to...
I'm not totally sure, It seems like it's just not pulling out the ranked as it's supposed to. I would try using ALLSELECTED instead of ALL in your ranking measure.
Changing to allselected didn't work :( Thank you for answering, though :)
I'm looking at this again, I think the rank formula is not quite right.
Try replacing the Calculate portion with your measure for the sum of sales.
I hope that works for you.