KNOWLEDGE BASE

Show Fixed Rank of a Measure When Using a Filter


Published: 25 Sep 2020
Last Modified Date: 01 Feb 2021

Question

How to get a fixed rank with a filter in a cross table. which means if the filter narrows the data showing in the table, the rank should be as same as the rank with the whole table.
User-added image    User-added image

Environment

  • Tableau Desktop

Answer

Create a calculation field to replace the [Region] field in [Filter] shelf.

The calculation is as below:
LOOKUP(ATTR([Region]),0)

User-added image

Please see the attached workbook.
Did this article resolve the issue?