Forum Discussion

eliasayyy's avatar
eliasayyy
Memorable Member
3 years ago
Solved

Wrong Ranking after adding new column

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
)
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hello eliasayyy 

    Please try

     

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

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello eliasayyy 

    Please try

     

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