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 figur...
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 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