Calculated Rank and Quartile measure in visual

[Livia_Hernandez]

Good Day - I recently (with help) was able to get my visual as I needed!  All the stores are ranked on Sales to Budget and then separated into 4 Quartiles based on Rank.  

Here is my issue:  I want to add in Region Code that DOES NOT change the rank and Quartile but only displays that specific region in the visual.  Sort of just hides the other regions so that regional manager can see quickly where all his stores fit within the company.

This is the visual when all regions are selected.  When I go to look at HTX region - it litterally filters the dataset and the ranks and quartiles mess up.  

In EXcel it is easy....

Essentially - I don't want the filter to filter on the results but just what one sees.  Any help???  🙂

[Livia_Hernandez · Accepted solution]

A really nice power user:   @Parvinder Chana solved this for me!!  I needed to use "ALL" and not "SELECTALL" in my ranking measure.

Thx!