Forum Discussion

alee5210's avatar
alee5210
Helper II
2 years ago

RANKX Using A Parameter

Hello everyone, I am trying to use a parameter with the RANKX function. The situation is like the below   I have 3 tables 1. 'Store' - A lookup table which matches one value to another. There is a...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
2 years ago

alee5210 , if you sort on sol measure, it should remain on that.

 

If you want to switch rank based on field parameter selection, refer

Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

 

You can use Rank as Var or measure to switch

 

If you want keep sorting on Store/Axis, when you switch, use this

Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw

  • alee5210's avatar
    alee5210
    Helper II
    2 years ago

    I assume you mean if I sort on the 'Store Rank By Items Sold' measure it should stay like that? But it does not, because in my chart I am using the parameter rather than the Figures'[Store Anonymous Name] field.

     

    Also I am not looking to do top N, I want all stores to be in the data. Will this still be an option if the date range has been cut and there are very few stores but my top N says top 50 stores? Will there be a lot of blanks left over?