You'll have to use temp tables to get the data resident and then filter after you can combine the data.
Sounds like you already get all Master_Fact (or it has a "stand alone" filter). Load it first.
Create a temp table for Charge_dimension, apply any other filters you can to limit load.
Then join the Charge_Amount to the Charge_Temp to create another temp table.
Then LOAD RESIDENT from Charge_Temp2 where where not year(today(0))*12)+month(today(0))) - (((year(“Date of Service”)*12)+month(“Date of Service”))) > 25 in the Charge_Dimension section and Where not “Owed Amount = 0”
Then delete temp tables.