Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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 

Status: Delivered

Kindly see the comments below.

 

 

 

Comments
v-tianyich-msft
Community Support
Status changed to: Accepted

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

 

v-xiaoyan-msft
Community Support
Status changed to: Delivered

Kindly see the comments below.