Measure does not show the correct value

Hi there,

I have four tables (3 dim, 1 fact table). I have created a measure that reads the two columns from a two-dimension table and based on the value of those columns it calculates the life. The measure looks as follow:

Total Life =

Var _dist = MAX('Coastline Distance'[DISTANCE])

Var _500m = MAX('Conductor Life Cycle'[Within 500m] )

Var _500mto5k = MAX('Conductor Life Cycle'[500m - 5km coast])

Var _5k =MAX('Conductor Life Cycle'[> 5km to coast])

Var _conduct_type_size = MAX('Conductor Life Cycle'[Conductor Type-Size])

Var _conduct_typ_siz = MAX('sde overhead_line_evw'[Conductor Type-Size])

RETURN

IF( _dist < 500, _500m,IF(_dist>=500 && _dist <= 5000 ,_500mto5k,_5k))

 

When I show the measured value in the table visual, the measure value does not show the correct value. For example, in the following picture:

 

 The value of the total life column of the first row should be 84. But it shows 120. Could anyone help me where I made the mistake?

 

Sample here