Keep ranking after adding more columns in table

eliasayyy — Thu, 23 Mar 2023 10:26:48 GMT

hello everyone i have this table

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

here is the measure

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

Re: Keep ranking after adding more columns in table

johnt75 — Thu, 23 Mar 2023 10:53:41 GMT

Try

Ranking Campaigns By Time = CALCULATE ( RANKX ( ALLSELECTED ( Campaigns[Campaign Name] ), [Time CTR],, DESC, DENSE ), REMOVEFILTERS ( Campaigns[Code] ) )

topic Keep ranking after adding more columns in table in DAX Commands and Tips

Keep ranking after adding more columns in table

Re: Keep ranking after adding more columns in table