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 ran...
  • 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 )

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello eliasayyy 

Please try

 

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