The RANKX formula is not reflecting the correct results in CARD visual

[Kansetsuwaza]

Dear Community,

Basically, I am trying to do a hotel benchmark analysis in terms of their occupancy rates. 
As you see below, the MATRIX rank and CARD rank are not matching. 
I have 2 slicers that show hotel names and locations. In some cases, I would like to increase my sample size by choosing more than one location (it's A+B locations in my below sample ) but the rank level seems incorrect when I chose multiple locations.

I chose Hotel 2, It's rank should be 2 under location A and 3 under location A+B but CARD shows the rank as 2 for both situations.

 

Rank Occ = IF(HASONEVALUE('Survey Data'[Hotel Name]),RANKX(ALL('Survey Data'[Hotel Name]),[Occupancy Rate (%)]))
rankx new = RANKX(CROSSJOIN(ALL('Survey Data'[Hotel Name]),ALLSELECTED('Survey Data'[Location])),[Occupancy Rate (%)])

 

[Kansetsuwaza]

@amitchandak Have you had any chance to check my sample .pbix please?

[Kansetsuwaza]

@amitchandak 
Thanks for your valuable feedback. I checked your link but unfortunately, I could not manage to solve my issue.
You may find the sample .pbix HERE 

Thanks again.

[amitchandak]

@Kansetsuwaza , is the across table rank is not correct then refer

Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.