Target Line

Hi Anonymous ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.

(2) We can create a measure. 

target = 
var _total=9
var _max_date=CALCULATE(MAX('Table'[Physical Vehicle Delivered Time]),ALLSELECTED('Table'))
var _max_date_1=DATE(YEAR(_max_date),MONTH(_max_date),1)
var _max_date_2=DATE(YEAR(EDATE(_max_date,-1)),MONTH(EDATE(_max_date,-1)),1)
var _max_date_3=DATE(YEAR(EDATE(_max_date,-2)),MONTH(EDATE(_max_date,-2)),1)
var _KPI_Yes1 = COUNTROWS(FILTER(ALLSELECTED('Table'),[KPI Status]="Achieved"&& [Physical Vehicle Delivered Time]>=_max_date_1 && [Physical Vehicle Delivered Time]<=_max_date_1+2))
var _KPI_Yes2 = COUNTROWS(FILTER(ALLSELECTED('Table'),[KPI Status]="Achieved"&& [Physical Vehicle Delivered Time]>=_max_date_2 && [Physical Vehicle Delivered Time]<=_max_date_2+2))
var _KPI_Yes3 = COUNTROWS(FILTER(ALLSELECTED('Table'),[KPI Status]="Achieved"&& [Physical Vehicle Delivered Time]>=_max_date_3 && [Physical Vehicle Delivered Time]<=_max_date_3+2))
RETURN  (_KPI_Yes1+_KPI_Yes2+_KPI_Yes3)/_total

In my test table, January 2025 is the most recent data, so the calculations are for attainment from the 1st through the 3rd of each month for January 2025, December 2024, and November 2024, and based on your description of three months and three dates then the total is 9.

(3) Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.