Applying filter to report attribute but keep the rank as unfiltered

Question

I am creating "Rank" function on a calculated measure. It works fine. But when I filter on a column value the rank changes.

Is there a way I can apply filter on an attribute but keep the Rank as unfiltered or unaffected?

For Example, In the below screenshot I want to filter on the Bank Name but I do not want the "Bank Fee Rank" measure to change

When I filter on one Bank Name the rank becomes 1

Syamantak Saha · Answer

Seems like Rank is being applied after the Filter. Try storing Rank as a physical database object like a Temp table and select using a join.