Forum Discussion

abrownRPI's avatar
abrownRPI
New Member
5 years ago

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 for "Actual Production / Projected Production" and "Actual Insolation / Projected Insolation". For example, if the Expected Production is missing for January 2021, then I need to exclude the January 2021 Actual Production from the total amount in the table. I still want to display the Actual Production in the table though.

 

Need Help

4 Replies

    • abrownRPI's avatar
      abrownRPI
      New Member
      5 years ago

      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])
      )