Forum Discussion
Need to exclude specific value from being calculated in table total
I am missing values for certain months in my table due to issues onsite at this particular asset. Occassionally this will happen and cannot be avoided. My problem is that this throws off the ratios f...
Actual/Expected Production =
CALCULATE (
DIVIDE ( SUM('Asset_Management_Data'[Actual Production]), SUM('Asset_Management_Data'[Expected Production]) ),
FILTER(Site_Info, Site_Info[Site] <> "LFG")
)
Actual/Projected Insolation =
DIVIDE(
SUM('Asset_Management_Data'[Actual Insolation]),
SUM('Asset_Management_Data'[Projected Insolation])
)
- Ashish_Mathur
Super User
Hi,
Share the link from where i can download your PBI file.
