Why rank number changed after add a sort column for the Dimtable?

[YunJ]

Hi,

I made these two tables, I want them have the same Store sort. 

So I add a sort column for the DimStore. 

But as you see here, the MS Rank_CM has the wrong result. (Before I add the sort column, the rank result is correct.)

Here is the pbix link: 

https://www.dropbox.com/s/yqzm5j4m9tk57co/ppt%20-%20Copy.pbix?dl=0

Thanks a lot for your help!

[amitchandak · Accepted solution]

@YunJ , please add the sort column also in all or all selected

Rankx(all(Store[Store],Store[Store Sort]),[MS_CM_BLUE])

Rankx(allselected(Store[Store],Store[Store Sort]),[MS_CM_BLUE])

[YunJ]

@amitchandak Thanks a lot for your help!