Forum Discussion

DionTN's avatar
DionTN
Helper II
4 years ago

DAX function is not working

Anyone any idea why this is not working?

FirstValue = var selectie = SELECTEDVALUE(company[Name]) var EersteWaarde = CALCULATE(MIN(usermeasurements[AppointmentId]),FIRSTDATE(usermeasurements[OnderzoekVerichtOp])), FILTER(usermeasurements,usermeasurements[users.company.Name] = selectie)) return (EersteWaarde)

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    4 years ago

    Hi,

    I do not know what is the expected result, but I think you have one more   )   in the measure after the FIRSTDATE function.

     

     

     

  • DionTN's avatar
    DionTN
    Helper II
    4 years ago

    I am expecting a list of all first values of the selected company. Now it gives not an error but also not a list.