Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Im trying to get a mean for every first measurement. So i have a function which calculates all the first measurements. I want to use this to get the mean of all first measurements.
GemiddeldeLichaamssamenstellingEerste = var selectie = SELECTEDVALUE(company[Name]) var EersteWaarde = CALCULATE(MIN(usermeasurements[AppointmentId]),FIRSTDATE(usermeasurements[OnderzoekVerichtOp])) var LS = CALCULATE(AVERAGE(usermeasurements[BodyCompositionOverall]),FILTER(usermeasurements,usermeasurements[users.company.Name] = selectie), (usermeasurements[appointments.AppointmentNumber]= EersteWaarde)) return COALESCE(LS/10,0)
When i select just 1 name it is working, but when i select a couple of names it fails.
Solved! Go to Solution.
Im sorry, the mistake was probably in the defination of FirstValue.
It reads only the lowest firstValue. So in this example, only richard will get a score cause of he has appointmentID 1
FirstValue = var selectie = SELECTEDVALUE(company[Name]) var EersteWaarde = CALCULATE(MIN(usermeasurements[AppointmentId]),FIRSTDATE(usermeasurements[OnderzoekVerichtOp]), FILTER(usermeasurements,usermeasurements[users.company.Name] = selectie)) return EersteWaarde
SELECTEDVALUE only work when there is a single value, otherwise it will return blank. Try
GemiddeldeLichaamssamenstellingEerste =
VAR selectie =
ADDCOLUMNS (
VALUES ( company[Name] ),
"EersteWaarde",
CALCULATE (
MIN ( usermeasurements[AppointmentId] ),
FIRSTDATE ( usermeasurements[OnderzoekVerichtOp] )
)
)
VAR LS =
CALCULATE (
AVERAGE ( usermeasurements[BodyCompositionOverall] ),
TREATAS (
selectie,
usermeasurements[users.company.Name],
usermeasurements[appointments.AppointmentNumber]
)
)
RETURN
COALESCE ( LS / 10, 0 )
Im sorry, the mistake was probably in the defination of FirstValue.
It reads only the lowest firstValue. So in this example, only richard will get a score cause of he has appointmentID 1
FirstValue = var selectie = SELECTEDVALUE(company[Name]) var EersteWaarde = CALCULATE(MIN(usermeasurements[AppointmentId]),FIRSTDATE(usermeasurements[OnderzoekVerichtOp]), FILTER(usermeasurements,usermeasurements[users.company.Name] = selectie)) return EersteWaarde
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
128 | |
29 | |
28 | |
24 | |
22 |