How to do sequential ranking in Power Bi

Hi guys! 

Does anyone could give me some advice on these two problems please?

1) I have different rankings for Assets, and I would like to apply them sequentially, like in the following example. 

- I have 7 Asset Codes in my example database, and if I apply the Market Value ranking and limit my number of positions to the first 3 Assets (thus Asset Code number 1 is the one with the highest market value and so on), I'd get this:

After If I apply the Volatility ranking (the ones with the lowest volatility values get the first positions), the expected result would be this:

Asset     Rank Volatility

AESB3            1

TTEN3            2

RRRP3            3

If I simply put the rank volatility together with the first table, it returns me the rank considering more than these 3 Asset Codes, like this:

2) After, I would like to be able to restrain also the quantity of Asset Codes for the subsequent rankings, like this:
            2.1) I choose to show the 6 first Asset Codes positions with the Market Value ranking;
            2.2) And after I filter the 3 first Asset Codes positions with the Volatility ranking from these 6 prior Asset Codes.

Does anyone have an idea how it could be done?

Here is the example file: https://drive.google.com/file/d/1N_g1fl5zkXibp6vNwy9s_oBifJCiGu0n/view?usp=sharing  

Thanks! 🙌