Forum Discussion
Solved
Need help with my formula
Hello, I need some help with my formula. Totaal m1 geul = Countrows(filter(adressen;adressen[Project]="A"|| (adressen;adressen[Status]="Closed"))*[Gem.Lengte p/woning]) I need to filter b...
Ah, sorry, my bad!
With CALCULATE, rather than using the '&&', simply replace with a comma - e.g.
CALCULATE (COUNTROWS (adressen), Adressen[Project] = "A", Adressen[Status] = "Closed") * Length
That should work.
Ah, sorry, my bad!
With CALCULATE, rather than using the '&&', simply replace with a comma - e.g.
CALCULATE (COUNTROWS (adressen), Adressen[Project] = "A", Adressen[Status] = "Closed") * Length
That should work.
JDLee23
That did the trick, thank you