topic KPI Card Behaviour Changed? in DAX Commands and Tips

KPI Card Behaviour Changed?

Anonymous — Mon, 27 Jan 2025 11:59:08 GMT

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.

Re: KPI Card Behaviour Changed?

BeaBF — Mon, 27 Jan 2025 12:58:22 GMT

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

Re: KPI Card Behaviour Changed?

Anonymous — Tue, 28 Jan 2025 18:02:03 GMT

Hi
Thanks for coming back to me and sorry a bit slow - been a day!!

No change at all, completely the same behaviour

Re: KPI Card Behaviour Changed?

Anonymous — Tue, 28 Jan 2025 18:05:47 GMT

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) * 100

KPI_Avg_CSAT = VAR AvgNPS = AVERAGE('Cases'[Survey Response.Score]) RETURN IF(ISBLANK(AvgNPS), 0, AvgNPS)

Re: KPI Card Behaviour Changed?

Anonymous — Fri, 31 Jan 2025 10:26:50 GMT

My problem seems to relate to the trend axis and I found a random and very different forum post where another user ended up using a date field from an unrelated data source in the trend axis, that seems to have worked for me!