Forum Discussion

kkjj's avatar
kkjj
Frequent Visitor
3 years ago

Divide by area

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

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      kkjj
      Frequent Visitor
      3 years ago

      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.