Issue with Averaging Values Across Filtered Descriptions After Table Merge

Here's a breakdown of all the data required to grasp the context. I am attempting to calculate the average using a calculated column in [MediaTrocaCol], but it results in multiple averages for the same [Complete Description]. After filtering out zeros, the average should have been 743.77 for all descriptions, I was only able to include 10 lines. I am also including all calculated columns relevant to this calculation.

[DiferençaHorimetro] represents the difference between the last and the penultimate change of the same description [Complete Description] for the same equipment (same [TAG]). The DAX formula is as follows:

```
DiferençaHorimetro = IF(ISBLANK('SAP - MB51'[HorimetroTrocaPenultima]),0,
'SAP - MB51'[HorimetroTrocaUltima] - 'SAP - MB51'[HorimetroTrocaPenultima])
```

[HorimetroTrocaPenultima] is the hour meter reading for the penultimate change of the equipment [TAG]. The DAX formula is:

```
HorimetroTrocaPenultima =

VAR Description = 'SAP - MB51'[Complete Description]
VAR Equipment = 'SAP - MB51'[TAG]
VAR LastPurchaseDate = 'SAP - MB51'[PreviousChangeDate]

RETURN CALCULATE(
MAX('SAP - IK17'[MEASURED_VALUE]), 'SAP - IK17'[EQUIPMENT] = Equipment, 'SAP - IK17'[NOMINATION]="HOUR METER", 'SAP - IK17'[CREATION_DATE] <= LastPurchaseDate)
```

[HorimetroTrocaUltima] is the hour meter reading for the latest change of the equipment [TAG]. The DAX is:

```
HorimetroTrocaUltima =

VAR Description = 'SAP - MB51'[Complete Description]
VAR Equipment = 'SAP - MB51'[TAG]
VAR LastPurchaseDate = 'SAP - MB51'[ENTRY_DATE]

RETURN CALCULATE(
MAX('SAP - IK17'[MEASURED_VALUE]), 'SAP - IK17'[EQUIPMENT] = Equipment, 'SAP - IK17'[NOMINATION]="HOUR METER", 'SAP - IK17'[CREATION_DATE] <= LastPurchaseDate)
```

[PreviousChangeDate] is the valid date (excluding chargebacks) when the item [Complete Description] was last changed. The DAX is:

```
PreviousChangeDate =

VAR Description = 'SAP - MB51'[Complete Description]
VAR Equipment = 'SAP - MB51'[TAG]
VAR CurrentDate = 'SAP - MB51'[ENTRY_DATE]
VAR FilteredTable =
FILTER(
ALL('SAP - MB51'),
'SAP - MB51'[TAG] = Equipment &&
'SAP - MB51'[Complete Description] = Description &&
'SAP - MB51'[ENTRY_DATE] < CurrentDate
)

VAR PenultimateDate = MAXX(FilteredTable, 'SAP - MB51'[ENTRY_DATE])

RETURN PenultimateDate
``