Forum Discussion

BICrazy's avatar
BICrazy
Icon for Helper II rankHelper II
4 years ago
Solved

Help needed with Dynamic Filtering for RANKX Function

Hi there Power BI Community,   I've hit a roadblock with regards to filtering whilst ranking a column   I have 3 Columns i.e. Countries, Region and Sub-Region which are each ranked by a value, wh...
  • BICrazy's avatar
    BICrazy
    4 years ago

    Hi there all,

     

    Apologies for the delay in my post.  Here is the link to the pbix file which contains the solution.
    Test_RankX using Measure 

    Kind regards

    Rakesh

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

If you don't want the rank to change in response to filters, then it sounds like you want static ranking rather than dynamic ranking, in which case you may want to define rank via calculated columns rather than measures.