Forum Discussion
KPI stopped working
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'[P...
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]))