The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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)
I am expecting a list of all first values of the selected company. Now it gives not an error but also not a list.
Hi,
I do not know what is the expected result, but I think you have one more ) in the measure after the FIRSTDATE function.
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |