Getting Average based on Latest entry

Try, Some thing like

Total = Calculate(
    sumx(   
            SUMMARIZE(
                data,
                data[company],
				data[geography],
				"_Min",
				minx( filter(data,data[Deal Size(min)]>0,data[date])),
                "_Max"
				minx( filter(data,data[Deal Size(max)]>0,data[date])),
				"_comp"
				max(data[company]),
				"_geo"
				max(data[geography])
            ),
            calculate(
                divide(_Min+_Max,(if(isblank(_Max),0,1)+if(isblank(_Min),0,1)))
                
            
    )
)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601