Anonymous
2 years agoNot applicable
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
- AnonymousNot 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 - AnonymousNot applicable
Kindly see the comments below.