Forum Discussion
Post ProdigyNeed help with my formula
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.
Post ProdigyThank you for your help
however the formula still has an error
Totaal m1 geul = CALCULATE(COUNTROWS(adressen);Adressen[Hoofdproject]="A" && 'Adressen'[Status Civiel]="Gesloten")*[Gem.Lengte p/woning]
The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression.
Helper IAh, 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.
- RvdHeijden
JDLee23
That did the trick, thank you