LOOKUPVALUE unexpected blank value

Hello, I need to determine person rank based on estimated full year performance. I tried to use an approach from this post but not fully working in my case Solved: Lookup closest value to a number - Microsoft Fabric Community

Here is sample result of my report:

• Rank 2023 is rank gained for 2023
• Rank limit is a limit for rank gained for 2023
• Full year performance is annualized YTD performace
• Full year perfotmance = CALCULATE(SUM('Person'[YTD performance])/MONTH(TODAY())*12)
• Estimation of Rank Based on Full year performance
• This is the problematic column. What I want to do is determine Rank based on Full year performace. Basically, take the Full year performance, connect it with rank table (provided below) and print Rank.
• Estimation of Rank Based on Full year performance =

var Full year perfotmance = CALCULATE(SUM('Person'[YTD performance])/MONTH(TODAY())*12)
var lowerRange = maxx(filter(all('Rank limits'[Rank limit]), 'Rank limits'[Rank limit] < Full year performance), 'Rank limits'[Rank limit]')
return LOOKUPVALUE('Rank limits'[Rank], 'Rank limits'[Rank limit]' , lowerRange)

• lowerrange is result of var lowerRange
• lowerange =

var Full year perfotmance = CALCULATE(SUM('Person'[YTD performance])/MONTH(TODAY())*12)
var lowerRange = maxx(filter(all('Rank limits'[Rank limit]), 'Rank limits'[Rank limit] < Full year performance), 'Rank limits'[Rank limit]')
return lowerRange

• lower range without var syntax is another problematic column where I do not understand the results. I would expect the same result like from lowerrange measure
• lower range without var syntax = maxx(filter(all('Rank limits'[Rank limit]), 'Rank limits'[Rank limit] < CALCULATE(SUM('Person'[YTD performance])/MONTH(TODAY())*12)), 'Rank limits'[Rank limit])

Table relations:

Person[PersonID] 1<->1 ChosenPeople[PersonID] (one-to-one)

ChosenPeople[Rank] *<->1 Rank limits[Rank] (many-to-one)

These are data from Rank limits table:

My questions are:

1) Why I do not get the results I am expecting (see the picture above, red writing) and I have blank values?

2) Why does measure lower range without var syntax give blank values? Is it related to problem number 1?

Thank you for help and forgive me if I am missing something obvious 🙂