Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 figur...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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)