Need to exclude specific value from being calculated in table total

[abrownRPI]

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.

[aj1973]

Hi @abrownRPI 

Can you show us your DAX formulas?

[abrownRPI]

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

[aj1973]

Hi @abrownRPI 

It is still hard to catch the issue this way. Can you share your PBIX file please?

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.