Question
The following measure successfully calculates the cumulative CO2 emissions per building present in my data model, based on electricity and gas usage of each building. The buildings are in a different table than the measure, and so are their square meters of floor area.
Cumulative CO2 Emissions Year per Building =
IF(
MONTH([Date ]) < MONTH(TODAY());
ElectricityTelemetryData[Cumulative CO2 Emission Electricity Year]+GasTelemetryData[Cumulative CO2 Emissions Gas Year];
BLANK()
)
Now I want to divide this measure by the square meters that belong to each building. Strangely enough, the following DAX code doesn't work, and it gives the message "The column 'Buildings[HouseSizeInSquareMeters]' either doesn't exist or doesn't have a relationship to any table available in the current context." Even though the tables ARE related, albeit indirectly, and I have already tried switching cross-filter directions of relationships from single to both.
Cumulative CO2 Emissions Year Per Building per m² =
DIVIDE(
'MetaUtilityTypes'[Cumulative CO2 Emissions Year Per Building];
RELATED(Buildings[HouseSizeInSquareMeters])
)
Hope somebody can help!
Kind regards,
Robin
