RANKX with TABLE VISUALIZATION fields from two different tables

[gusio]

My table Visualization has the following values:
Store ID, Type, Ranking, SalesTotal. I've added RankX formula to rank my data , it works fine... but....

SALES TOTAL = SUM(powerBI_data[Current])

Ranking = if(hasonevalue(powerBI_data
[StoreID]),(RANKX(ALL(powerBI_data[StoreID]), [SALES TOTAL])))

Now when I am trying to add Values from a linked table my ranking is off?

I wish I could add Salesperson Name which comes from SalesPerson Table
and add StoreDescription which comes from Store Table , how can I do this without ruining my ranking?
Thank You,

 

[gazpage]

Sorry to be critical when you are asking for help, but your question is nowhere near clear enough for me to understand. What are the tables and columns in your data? What are the relationships between tables, and are they one or bi directional? You say you added RANKX, is that a measure or calculated column?

On the face of it, your ranking formula is removing filters from the storeid, but not other columns. I would expect any filters applied to other columns to still apply. In absence of a more detailed description, replace the ALL part of your expression with CALCULATETABLE ( VALUES ( PowerBi_data[StoreID] ), ALL ( PowerBI_data ) ).