Forum Discussion
Post ProdigyNeed help with my formula
Post ProdigyThanks for your help but i haven't tried your option yet but i saw you want the average over ALL the houses and that i already have done but it didn't return the correct average.
The formula obviously was accurate but seeing that there can be a big difference in the meters per DP.
A DP (a cluster of Houses) might have 1000 meters and the other DP might have 100 meters so if we calculate an overall average it wouldn't be real.
That is why i want an average per DP is more accurate and that is why i used the Lookupvalue
Microsoft EmployeeHi RvdHeijden,
I didn't calculate the average over ALL the houses, [total hourse] is a calculated column, which returns each DP's hourses. Please create sample table and list expected result.
Best Regards,
Angelia
- RvdHeijden
you were rigth, my bad :)
The first part of the formula went fine, but the second one returned an error
total hourse = CALCULATE( COUNT(Adressen[id]);USERELATIONSHIP(Adressen[DP gebied naam];'Werkbegroting civiel'[DP naam]))
Average = DIVIDE('Werkbegroting civiel'[Graaflengte totaal];'Werkbegroting civiel'[total hourse])
A circular dependency was detected: Werkbegroting civiel[total hourse], Werkbegroting civiel[Average], Werkbegroting civiel[total hourse].
- RvdHeijden
v-huizhn-msftAny ideas ? is it the formula or the relationship(s) ?