Forum Discussion

Helper 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
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

BICrazy

Helper 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.