Idea Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
0
How to calculate/dive with already Outputed values from different tables
Submitted by
marvinLee
on
11-30-2023
09:29 AM
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
See more ideas labeled with:
Comments
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Latest Comments
- duarte on: Unable to sort months in PowerBI
-
mattlee on: “Add Value” in Textbox Not Visible in Dark Theme
- mattin on: Report Server Permissions Jan/May 2025
-
bhalicki
on: Bi Crashes on launch with (AS Process PID=XXXXXX H...
- stanteitelbaum on: authenticator wont trigger after purchase of new p...
-
Stinkys
on: Fix the Date function in DAX
-
Stinkys
on: Cannot login to community site
-
reubwork
on: May 25 update for Snowflake Connector v2 has broke...
-
dmkblesser
on: Unable to open existing PBIP files
- DamoUK on: Gateway issues
Idea Statuses
- New 8,019
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,088
- Declined 38
- Delivered 3,970
-
Reports
10,227 -
Data Modeling
4,130 -
Dashboards
4,111 -
Report Server
2,114 -
Gateways
2,112 -
APIS and Embedding
1,964 -
Custom Visuals
1,787 -
Content Packs
523 -
Mobile
354 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Tips and Tricks
1 -
Power BI Desktop
1