Calculate average from calculated values

[DionTN]

I have two calculated values and need to have the average and delta between those.

The second value is correct but the first isn't. How can i get the average of that one?

I have this function to get the average of first and last. And a new to get the average of the average.

GemiddeldeLichaamssamenstellingEerste =
VAR selectie =
    ADDCOLUMNS (
        VALUES ( company[Name] ),
        "EersteWaarde",
            CALCULATE (
                MIN ( usermeasurements[AppointmentId] ),
                FIRSTDATE ( usermeasurements[OnderzoekVerichtOp] ),
                FILTER (
                    usermeasurements,
                    usermeasurements[users.company.Name] = VALUES ( company[Name] )
                )
            )
    )
VAR LS =
    CALCULATE (
        AVERAGE ( usermeasurements[BodyCompositionOverall] ),
        TREATAS (
            selectie,
            usermeasurements[users.company.Name],
            usermeasurements[AppointmentId]
        )
    )
RETURN
    COALESCE ( LS / 10, 0 )

Gemiddelde van GemiddeldeLichaamssamenstellingTweede per BodyCompositionOverall = 
AVERAGEX(
	KEEPFILTERS(VALUES('usermeasurements'[BodyCompositionOverall])),
	CALCULATE([GemiddeldeLichaamssamenstellingEerste])
)

[MFelix · Accepted solution]

Hi @DionTN ,

If the two values are already calculated measures you need to only do the average of both of them:

Average of two values= AVERAGE ([Value1], [Value2])

This should get the expected result since the use of metrics within another metrics forces the use of CALCULATE that will make your calculation work properly.