Changing Colour range for Diffrent Entity on Tachometer

Dear Colleageus,

I have two Entities (A and B) with different Budget and Expenditure value.

I will like to apply a DAX Measure on the [Range2] and [Rang3] start Value of the Tachometer visual to diplay Yellow and Green color for different Entity selected on the slicer.

I did for one Entity and it is fine, but when I change to the second Entity, - The Colour format i specified for the 1st entity is not applicable to the 2nd entity, because 2nd entity has a maximum amount of 3M, which is lower than the first entity.

COLOUR FORMAT NOT WORKING ON THE SECOND ENTITY

3.8M Target is lower than the RANGE 2 value, for the Yellow and Green Colour to apply

Can you please assist with to write a DAX measure/function like conditional forwarding, that can be applied on the Range 2 start value and Range 3 start value, to apply differe colour in the the visual as RED, YELLOW AND GREEN, Irrespective of Entity selected on the slicer.

ENTITY = NMC - Indication as follows

0M - 2M = RED

2M - 2.5M = YELLOW

2.5M - and above = GREEN

ENTITY = IOWA - Indication as follows

0M - 5M = RED

5M - 10M = YELLOW

10M - 15M = GREEN

Thanks for your support.