Rankx not working

[youconnect]

Hi,

I need your help.
I apply rankx in my model and it's working in image 1. But when I add the Hub the visual table the ranking it's not working.
My .pbix file:
https://drive.google.com/file/d/1jr5ThOaq0R1dAm9mRNKmDrCvx3mHIwSk/view?usp=sharing

[amitchandak]

It seems like working. Your relation with HUB has a problem. See the numbers are repeating and raking for each user is still correct based on sales amount.

[youconnect]

@amitchandak But I want keep the ranking from image 1 but with information of image 2.

[amitchandak]

Images missing.

[youconnect]

@amitchandak Fixed images

[v-xuding-msft]

Hi @youconnect ,

Could you tell me if your problem has been solved?

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft]

Hi @youconnect ,

I don't understand your requirement clearly. For pic 2, the result is still working for the column "name". It is same as the pic 1. Can you please show your expected results while adding the column "hub"?

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.