Forum Discussion
KPI Card Behaviour Changed?
Hello,
I've had a Power BI Report that I've been using for about a year without issue and for some reason it is no longer filtering correctly on the KPI cards and I can't for the life of me figure out why!
Example:
Measure for the calculation of the % of cases resolved in 1 day:
KPI_Pct_CasesResolved1Day =
VAR TotalCases = COUNTROWS('Cases')
VAR CasesAge1OrLess = CALCULATE(COUNTROWS('Cases'), 'Cases'[Case Age] <= 1)
VAR Percentage = DIVIDE(CasesAge1OrLess, TotalCases, 0) * 100
RETURN
IF(ISBLANK(Percentage), 0, Percentage)
Measure for the KPI Card's goal:
KPI_TTR_1 - L3 = 50
I then display that KPI card three times and fitler the card by Resolved Date with Relative date ranges of 30, 60 and 90 days. This has always worked just fine until recently, and the only thing that I changed recently was the Target measure from 25 to 50.
I can influence the card with the relative date filter, but the values are only updated when the relative date is recent - i can filter the card up to a relative date range of "In the last 25 Days" but anything higher than that and the values do not update.
There are no other filters in place on the visual or page.
This is affecting all of my KPI cards, not just this measure and I'm worried that I'll have to move to Cards with conditional formatting which would be a lot of effort as the report is around 50 pages with around around 500 KPI cards in use across the whole thing...
Is this a known issue? I've struggled to find anything to explain it!
Edit: I should mention that I tried brand new measures and a completely different dataset and found the same behaviour to occur there.
4 Replies
Anonymous Hi!
Try with:
KPI_Pct_CasesResolved1Day =
VAR TotalCases = COUNTROWS('Cases')
VAR CasesAge1OrLess = CALCULATE(COUNTROWS('Cases'), 'Cases'[Case Age] <= 1)
VAR Percentage = DIVIDE(CasesAge1OrLess, TotalCases, 0) * 100
RETURN
IF(TotalCases = 0, BLANK(), Percentage)is there any change in your output?
BBF
Some other variants of measures that do the same thing on KPI cards... To me it feels like a bug since these were all working and broke at the same time
KPI_Pct_CasesResolved10Days = VAR TotalCases = COUNTROWS('CS.Case') VAR CasesAge1OrLess = CALCULATE(COUNTROWS('Cases'), 'Cases'[Case Age] <= 10) RETURN DIVIDE(CasesAge1OrLess, TotalCases, 0) * 100KPI_Avg_CSAT = VAR AvgNPS = AVERAGE('Cases'[Survey Response.Score]) RETURN IF(ISBLANK(AvgNPS), 0, AvgNPS)
