Simple formula i thought

[RvdHeijden]

Goodday,

I need some help with this formula 

Klacht per woning = DIVIDE(FILTER(Adressen;[civiel gesloten]<>BLANK());COUNT(Klachten[ploeg]))

This formula should be farely straight forward but it returns an error that the expression refers tot multiple colums and they can't be converted to a scalare value ?

Basically what i want to do is filter in table 'Adressen' on all rows where the colum 'Civiel gesloten' has a value and devide them by the number of complaints per team in the table 'Klachten'.

[Greg_Deckler · Accepted solution]

Right, it is because FILTER returns a table and you need a scalar for all the parameters of DIVIDE. Perhaps try:

Klacht per woning = DIVIDE(COUNTROWS(FILTER(Adressen;[civiel gesloten]<>BLANK()));COUNT(Klachten[ploeg]))