Wrong Ranking after adding new column

[eliasayyy]

hello everyone i have 3 tables , campaigns , time of day , fact table

i have this table visual

which the ranking is correct 

but when i ad time code to the table i get wrong ranking

how can i keep the same ranking as first table even after adding code

note that i have a relationship between fact table and both time day table and campaigns table

so campaign name comes from campaigns tables , the code comes from time of day table and my calculation is from fact table

how can i keep the ranking before adding code

here is the measure 

Ranking Campaigns By Time = 
RANKX(
    ALLSELECTED(Campaigns[Campaign Name]), 
    [Time CTR],
    ,
    DESC,Dense
)

[eliasayy · Accepted solution]

Hello @eliasayyy 

Please try

Ranking Campaigns By Time = RANKX( ALLSELECTED(Campaigns[Campaign Name]), CALCULATE([Time CTR],All('Time'[Code])), , DESC,Dense )