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.
Helper IHi,
I think you need to use the CALCULATE function (https://msdn.microsoft.com/en-us/library/ee634825.aspx), to allow you to filter as you need.
E.g. Totaal m1 geul = CALCULATE( COUNTROWS ( adressen ) , adressen[Project] = "A" && adressen[Status] = "Closed")) * AVG (length measure)
The '&&' gives you the AND operator (rather than ||, which is an OR operator). The formula above will count the rows in the table 'adressen' which have Project = A, and Status = Closed, multiplied by the average length measure.
Hope this helps!
- RvdHeijden
Thank 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.
- JDLee23
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.
- RvdHeijden
JDLee23
That did the trick, thank you
