How can I use Sort by Column and RANKX at same time.

Hi all,

I used RANKX to set up my Power BI report before. But today I got some problems when using RANKX and Sort by Column function at the same time. I really need you help, I really appreciate that.

This is my test data, Product is sort by Product as normal

These are 2 measures to test data:

test_c = CONCATENATEX(ALL(test[Product]),CALCULATE(SUM(test[Qty])),,",",ASC) 

test_r = RANKX(ALL(test[Product]),CALCULATE(SUM(test[Qty])),,ASC) 

The result looks well. But I want to sort Product by column "Sort" 

After that when I come back to my 2 measures, it's give wrong number. I dont know why?

I did research a lot around to this problem, but I still did not get the answer. Did anyone get into this situation before, how can I solve this problem?

Thank you all