Need KPI to show aggregate value when filtering

PowerBIUser349 — Thu, 23 Feb 2023 15:50:28 GMT

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.

topic Need KPI to show aggregate value when filtering in DAX Commands and Tips

Need KPI to show aggregate value when filtering