Forum Discussion
Sum the total KPI
Hi, Does anyone know how to solve 2 of my problems when I'm using KPI Indicator: 1- The trend axis doesn't shows the monthly trend (Jan-Mar). Jan=no data; Feb & Mar= had data. The trend only s...
Hi atiyah
the trend axis doesn't show the blank value, a workaound is to set the blank to 0.
the actual value in KPI shows the value for the last item in the trend axis, try this formalu to get total value
Actual 20181 = CALCULATE ( COUNTROWS ( Details ), ALL ( Details ) )
Best regards
Maggie
Hi v-juanli-msft,
Thank you so much for the reply.
Really appreciate it.
I tried your formula, the new problem raise where the value is invalid.
The line still didn't show the trend from Jan-Mar.
Formula: Actual 2018v1 = CALCULATE(COUNTROWS(Details), ALL('Details'))
Kind regards,
Atiyah