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:
My Target:
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%.
2 Replies
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/1447523When 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]))
