Forum Discussion
Post ProdigyNeed help with my formula
Goodday,
I need a little help with my formula
Gemiddelde m1 sleuf =
CALCULATE((
LOOKUPVALUE('Werkbegroting civiel'[graaflengte totaal];'Werkbegroting civiel'[DP naam];ADRESSEN[DP gebied naam])/
LOOKUPVALUE('Werkbegroting civiel'[Aantal adressen per DP];'Werkbegroting civiel'[DP naam];ADRESSEN[DP gebied naam])))
I need this formula to calculate the 'Graaflengte totaal' and devide it by the number of houses per group to get an average.
i tried sumx but that didn't work and neither does calculate.
A single value for column 'DP gebied naam' in table 'ADRESSEN' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
in the table Werkbegroting civiel [DP naam] is unique and in ADRESSEN[DP gebied naam] it is not, is that the problem ? if yes then how do i correct it
9 Replies
- RvdHeijden
Anonymous
Basically the formula should calculate the total amount of meters dug and devide it by the amount of houses in that are area
So ... for example:
The first part of the formula should return the value '1000' (meters)
LOOKUPVALUE('Werkbegroting civiel'[graaflengte totaal];'Werkbegroting civiel'[DP naam];ADRESSEN[DP gebied naam])/
The second part of the formula should return '50' houses
LOOKUPVALUE('Werkbegroting civiel'[Aantal adressen per DP];'Werkbegroting civiel'[DP naam];ADRESSEN[DP gebied naam])))
And those values should be devided .... 1000/50=200
Hi RvdHeijden
It will be of great help if you can post some sample data of the diffrent tables in the data model.
From your formula, what are you using the lookupvalue for ?
Cheers
CheenuSing
