Mapping a Dynamic Range to a Static Border

Dear Community, first of all. Sorry for my bad english. I have a very big challenge. I have several items where I calculate the range filtered by location. In this example you see 3. Now I ...