Forum Discussion
dynamic ranking by sorting
Hello all, I have built a ranking by delivery quantity. As in the image. But now I want that the ranking is automatically adjusted according to my sorting. So if I sort it by the last 14 days the ra...
amitchandak
Super User
Super UserAnonymous , What do you mean by sort for the last 14 days?
Rank is created on a column or set of column and measure and remains on that.(with all used in rank filter will not work, with allselected filter will work )
You can make it dynamic using a switch
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns