Need KPI to show aggregate value when filtering

Hi Everyone, 

I am having troubles with the Microsoft KPI visual and hoping you all can help. I would publish my pbi file, but apparently I don't have enough creditability yet. Below you will see my table that I am visualizing. I want to show the most recent completed month therefore I am using the "Month Completed" column in my filters. The KPI works great until I want to filter to a certain range of Months. For example, If I want to see Q4 in 2022 then I filter to Oct. 2022, Nov. 2022, and Dec. 2022. However the KPI doesn't aggregate the three months like I need. It only shows the last month - Dec. 2022. 

Raw Data:

KPI Before Filtering

KPI once filtered. I would like this to aggregate the three months I have selected rather than show the most recent month.