Applying filter to report attribute but keep the rank as unfiltered

Raghu_Nandan

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 Balancing Segment but I do not want the "Inverse Rank NAS" measure to change

When I filter on one Balancing segment the rank becomes 1

Bhaskar Konar

Hi @Raghu_Nandan,

Would it be possible for you to share the screenshot when you are selecting 'Balancing Segment' as a filter. It'll be helpful for understanding the issue especially how the Ranking is getting changed.

Cheers,

Raghu_Nandan

Hi @Bhaskar Konar , Please refer to below screenshot
When I filter on 1009 Balancing segment I want the Rank measure to show "6" as seen in earlier screenshot
So basically I want to Ignore filter for the Rank measure
Since Rank is calculated dynamically on the resultset am not getting the desired result
Is there a way to achieve this?
I used "Selection steps" but there also if I filter on the Balancing segment the result is same

Bhaskar Konar

Hi @Raghu_Nandan,

Thanks for the details.

Yes, you're correct. If you are calculating the rank within the Report runtime then it'll be always dynamic and it'll be applicable for selection of data-set.

If you are using DWH / FDI then you might want to create a view (using sqls etc) and calculate those Rank and then use that Rank in your model as a readymade calculated column to select the Rank in the Report. This way you can do a bit work around.

Hope this help.

Cheers,