Dynamic Ranking Based on Filters selection

[icdns]

Hi, 

I would like to ask for your help in creating a RANKING column and the Ranking will be dynamic based on the filters selected (In this case, i have dimensions in my table that I would like to use as my filters). 

Once I have my dynamic ranking column, I will then have another column that consists of my TOP 1 to 5 and others will be group as "OTHERS"

I tried this DAX below and it worked. However, It is showing 1 to XXX but when I filter it by any dimension it is not displaying the correct value. 

1) No Tie column = 'TABLE'[Sales]+RAND()

2) RANX Total Sales (No Tie) =

RANKX(

'TABLE',

'TABLE[No Tie column]

)

My Expectation: 

From this table:

To this: 

Others will be group to "Others" and their sales will be summed

Thank you!

[icdns]

This really helped! Thank you!

[amitchandak · Accepted solution]

@icdns , refer if these approches can help

https://goodly.co.in/top-n-and-others-power-bi/

https://www.proserveit.com/blog/ms-power-bi-topn-and-other