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

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, BICrazy 

 

I agree with them, but here I see that you haven't replied. Have you solved the problem? If not, please share some insensitive data samples and expected output. In addition, we don't know the codes of these two measures: [YoY% Change since 2010] and [Average Values WB], you also need to explain.

 

Best Regards,
Community Support Team _ Janey

 

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

    Hi there all,

    Apologies for the delayed response.  It's been a busy few weeks to the start of 2022...all Power BI related though ğŸ˜Š

    I tried using calculated columns for this exercise but the model became too slow as the fact table contains approximately 13M row's and I had to create 3 columns, 1 for the country, 1 for the region, and another for subregion.  These +/- 40 M iterations were causing the Power BI Desktop refreshes to timeout.  

    I then proceeded to build a model with measures using sample data which I tested and ended up working.  I will post the solution shortly.

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi BICrazy 

       

      You are welcome to share your solution, then you can accept it as solution.

       

      Janey