Display nth match

Hi Marion ,

In your code, I copy the rank part to a column, you can see there is no rank=2 when SKU="Apple",so it's blank.

Here's my solution.

1.Create a new table.

2.Create relationship of the two tables.

3.Create three measures.

1st = CALCULATE(MAX('Table'[Vendor]),FILTER('Table 2','Table 2'[RANK]=1))

2nd = CALCULATE(MAX('Table'[Vendor]),FILTER('Table 2','Table 2'[RANK]=2))

3rd = CALCULATE(MAX('Table'[Vendor]),FILTER('Table 2','Table 2'[RANK]=3))

 

I attach my sample bellow to help you to understand.

 

Best Regards,

Community Support Team_kalyj

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