Wrong Ranking after adding new column

eliasayyy — Thu, 23 Mar 2023 11:43:21 GMT

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 )

Re: Wrong Ranking after adding new column

Anonymous — Thu, 23 Mar 2023 12:02:39 GMT

Hello eliasayyy

Please try

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

topic Re: Wrong Ranking after adding new column in DAX Commands and Tips

Wrong Ranking after adding new column

Re: Wrong Ranking after adding new column