How to extract data from multiple columns and form a new column dynamically

[LucaixBolha]

Hello guys!

Could someone help me with this issue please? I have a pbix file with some asset codes (like AERI3, ABCB4, and so on, each one representing one enterprise), and also with some rankings that I've created. As you can see by the names of the sheets, one of them was made via Desktop method - measures, etc, - and the other one via Power Query method.

Be it via Desktop Method or Power Query, my goal is the following one: after I select the number of rankings and the Top N Assets' Codes that I would like to be displayed, it would be generated a new table containing only the Assets' Codes filtered by these selections. So, for example: 

In this case I selected the Rank P/BV and the Rank Market Value, altogether with "2" for the Top N slicer. The expected result is that a new table is generated, showing a list with the Assets QVQP3B, ABCB4, RRRP3 and AESB3 (respectively the first 2 positions from the Rank P/BV and the first two from the Rank Market Value; the order of Assets to be shown from the ranks chosen doesn't matter) 

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

Thanks! 🙏

[LucaixBolha · Accepted solution]

I got a solution (not exactly what I described, but it filters the asset column and leaves only the wanted Asset values):

I did a Top N slicer (just as in the following article), so that when I choose the positions of the rankings to be displayed, it filters everything, and gives me a list.
Dynamic TopN made easy with What If Parameter - Microsoft Power BI Community

[LucaixBolha]

Whoops, actually the result list in this example would be AESO3, QVQP3B, ABCB4, RRRP3 and AESB3, because in the Rank P/BV there's a tie at the first position between AESO3 and QVQP3B