Forum Discussion
Solved
IF with nested CALCULATE Measure between 2 tables not functioning
I am looking to create a measure which pulls from 2 tables. The tables I have are: * Building (includes data regarding a building's physical information) *Compliance (includes data regarding compli...
CALCULATE(
COUNTA(Compliance[Compliant]),
Compliance[Compliant]="no",
Building[Designation]="London"
)
This assume there is a relationship between the tables
If you want to learn more about that error look at row and filter context
Deku
Super User
Super UserCALCULATE(
COUNTA(Compliance[Compliant]),
Compliance[Compliant]="no",
Building[Designation]="London"
)
This assume there is a relationship between the tables
If you want to learn more about that error look at row and filter context
Thanks for a quick response that has fixed it. I've got a second measure to calculate total compliance within an area will adjust.
Kind Regards
Ryan