How to calculate/dive with already Outputed values from different tables

[marvinLee]

I like to divide SumTenantKWH with SumUtilityKWH from from image , which is already calculated measure 

for each Facility from 2 different output tables (TenantKWH,UtilityKWH)  

From the image

facility=DFW01  SumTenantKWH(4681698.36) /  facility=DFW01 SumUtilityKWH(7,339.50) = 628.4581  

facility=IAD01  SumTenantKWH(49,742,427.00) /  facility=DFW01 SumUtilityKWH(64,619,748) = 0.769771

Any help will be appreciated...

Thanks 

[Anonymous]

Hi @marvinLee ,

You can try the following expression:

DIVIDE = DIVIDE(MAX('TenantKWH'[SumTenantKWH]),MAX('Utility KWH'[SumUtilityKWH]))

Best regards,
Community Support Team_ Scott Chang

[Anonymous]

Kindly see the comments below.