0

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

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

 

marvinLee_0-1701365257609.png

Any help will be appreciated...

Thanks 

Delivered
Comments
avatar user
Anonymous
Not applicable

Hi @marvinLee ,

 

You can try the following expression:

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

vtianyichmsft_0-1701395352004.png

 

Best regards,
Community Support Team_ Scott Chang

 

avatar user
Anonymous
Not applicable

Kindly see the comments below.