Check DAX function Lastdate

[DionTN]

LastValue =
VAR LaatsteWaarde =
    CALCULATE (
        MAX ( usermeasurements[AppointmentId] ),
        LASTDATE ( usermeasurements[OnderzoekVerichtOp] ),
        FILTER ( usermeasurements, usermeasurements[users.company.Name] = [Bedrijf] )
    )
RETURN
    LaatsteWaarde

It looks like this function is giving more than 1 output argument. How can I realise this is only 1 argument?

When I want to use "Laatste waarde" it returns an average of more than 1 value.

BodyComp4 =
VAR LS2 =
    CALCULATE (
        AVERAGE ( usermeasurements[BodyCompositionOverall] ),
        FILTER (
            usermeasurements,
            usermeasurements[users.company.Name] = [Bedrijf]
                && usermeasurements[AppointmentId] = [LastValue]
        )
    )
RETURN
    LS2 / 10

[amitchandak]

@DionTN ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[DionTN]

 I have an SQL connection so can only share the raw data.

https://drive.google.com/drive/folders/1tBe_K_oL6eNNYd9tanZc5X5vxMZfbv-8?usp=sharing

My goal is to have the average of BodyComp4 based on the LastValue rows (and BodyComp3 based on the FirstValue rows)