Anonymous's avatar
Anonymous
Not applicable
2 years ago
Status:
Done

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

 

Any help will be appreciated...

Thanks 

2 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    You can try the following expression:

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

     

    Best regards,
    Community Support Team_ Scott Chang

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Kindly see the comments below.