KPI stopped working

[abureaux]

Everything was working up until this weekend, so I'm not sure why this stopped working.

When I look at the individual components, I get these...

My value:

kpi_v1 = 1-((SUM('Audit_Scorecards'[PEPReference:7])/2)/(Audit_Scorecards[Audits Completed]))

My Target:

kpi_target_v1 = 1-(MAX('KPI'[KPI_PEP7])/2)/MAX('KPI'[KPI_Total_Audits])

Resulting KPI:

When I make any changes to the filters I get this:

But when I apply the same filters while looking at the values used in above KPI in Cards, I get what I expect (KPI Target vs KPI Value):

Does anyone have an idea as to why these are acting up now?

EDIT: I should add that it seems like the Value component of the KPI is defaulting to 1 or 100%.

[abureaux]

When I checked this morning, I apparently didn't save my work yesterday, which means I was missing a data refresh. Prior to refreshing the data, the visuals work (see below), but as soon as I add more data, things break.

Unfiltered:

Filtered:

The KPI cards are set up with the following:

PEP_7 (Measure) = 1-((SUM('Audit_Scorecards'[PEPReference:7])/2)/(Audit_Scorecards[Audits Completed]))

Audits Completed (Measure) = COUNTAX(Audit_Scorecards,[Status])

Year = The [Audit Year] column from the below table.

KPI_Target_PEP7 (Measure) = 1-((SUM('KPI'[KPI_PEP7])/2)/MAX('KPI'[KPI_Total_Audits]))

[PEP_7] data:

Project Number	Manager	Audit Date	Status	Audit Year	PEP Reference: 7	PEP Reference: 8a and 20	PEP Reference: 8b	PEP Reference: 11	PEP Reference: 19	PEP Reference: 24	PEP Reference: 27	PEP Reference: 28	PEP Reference: 29	PEP Reference: 31	PEP Reference: 35 and 38
123456	Person1	1/16/2024	Approved	2023	0				0		0	0	0	0	0
123456	Person2	12-12-23	Approved	2023	0				0		0	0	0	0	0
123456	Person3	12-12-23	Timeout	2023	0				0		0	0	0	0	0
123456	Person4	12-11-23	Approved	2023	0				0		0	0	0	0	0
123456	Person5	12-11-23	Approved	2023	0				0		0	0	0	0	0
123456	Person6	12-11-23	Approved	2023	3				0		0	1	0	0	0
123456	Person7	12-07-23	Approved	2023	0				0		0	0	0	0	0
123456	Person8	12-04-23	Approved	2023	0				0		0	0	0	0	0
123456	Person9	12-04-23	Approved	2023	0				5		0	0	0	0	0
123456	Person10	12-04-23	Approved	2023	0				0		0	0	0	0	0
123456	Person11	12-04-23	Approved	2023	0				0		0	0	0	0	0
123456	Person12	12-04-23	Approved	2023	0				0		0	0	0	0	0
123456	Person13	12-04-23	Timeout	2023	3				5		0	0	2	0	3
123456	Person14	12-04-23	Timeout	2023	3				5		0	0	2	0	3
123456	Person15	11/18/2023	Timeout	2023	0				0		0	0	0	2	0
123456	Person16	11-06-23	Approved	2023	0				0		0	0	0	0	0

[KPI_Target_PEP7] data:

KPI = SUMMARIZE(

    Audit_Scorecards,

    Audit_Scorecards[auditYear],

    "KPI_PEP7", SUM(Audit_Scorecards[PEPReference:7]),

    "KPI_PEP8b", SUM(Audit_Scorecards[PEPReference:8b]),

    "KPI_PEP8and20", SUM(Audit_Scorecards[PEPReference:8aand20]),

    "KPI_PEP11", SUM(Audit_Scorecards[PEPReference:11]),

    "KPI_PEP19", SUM(Audit_Scorecards[PEPReference:19]),

    "KPI_PEP24", SUM(Audit_Scorecards[PEPReference:24]),

    "KPI_PEP27", SUM(Audit_Scorecards[PEPReference:27]),

    "KPI_PEP28", SUM(Audit_Scorecards[PEPReference:28]),

    "KPI_PEP29", SUM(Audit_Scorecards[PEPReference:29]),

    "KPI_PEP31", SUM(Audit_Scorecards[PEPReference:31]),

    "KPI_PEP35and38", SUM(Audit_Scorecards[PEPReference:35and38]),

    "KPI_Total_Audits",COUNTAX(Audit_Scorecards,[Status]))

[Ritaf1983]

Hi @abureaux 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523