Divide by area

[kkjj]

Hi

I am new to Power BI and would appreciate any help. 

I have the following tables. 

I would like to sum the [Calculated emissions t (CO2)]based on the BU and then divide it by the area based on BU.

I have gotten the total emissions by BU

EmissionsBU = CALCULATE(sum('Activity 2013'[Calculated emissions (t CO2e)]), ALLEXCEPT(Mapping,Mapping[BU]))

but can't figure out how to divide it by the correct Area.

Any help would be appreciated.

Thanks

[Anonymous]

Hi kkjj 

Thank you for reaching out to our community and welcome! 

If the Hotel column and the CZBU column have the same 'names" values, then go ahead and create a relationship  between the Hotel column, and the CZBU column.  From there you can divide by Area.  

Hope this helps! if not, send me a DM on the community and i would be happy to help you further!

Best, 

Kelly Kaye

[kkjj]

Hi Kelly

That didn't work. I still  get an error. 

But I don't want to sum the area. I just want to divide each entry in the large table by the corresponding. 

Thanks for your help.