Prioritize what value gets picked up in vlookup

Hi Anonymous,

You can do the following:

• Create a new table with the Ranking values and sort order in my example I added the following:

Rank       Sort

• Add a column to your table with full details with the following code:

Rank_Sort = LOOKUPVALUE('Rank'[Sort];'Rank'[Rank];Table2[Ranking])

• This column is auxiliary to get the Ranking sorting number
• Add the following measure:

First_Ranking = 
LOOKUPVALUE (
    'Rank'[Rank];
    'Rank'[Sort]; MINX (
        SUMMARIZE (
            Table2;
            Table2[ID];
            "RANK"; MIN ( Table2[Rank_Sort] )
        );
        [RANK]
    )
)

Then add the levels you need to have the value as you want.

As you can see the colours are matching with the first rank in the ranking table.

Although there is a repetion on the column rank_sort this is need to have a way of getting the order you need. 

The table 1 and table 2 have a relantionship between them as I posted in my fist answers that's why I'm choosing ID from table 1 and measure is on table 2.

Regards,

MFelix