Forum Discussion
KPI Target Goal issue
Hi all!
I have a KPI issue where my Target goals value is making my KPI blank. It appears that it is creating a blank row as shown on the data table. This only appears when I insert the Target goal.
Calucation for my Indicator is:
"€/kWh = (SUM('Proceeding'[Grant €])/(SUM('Proceeding'[Sum of Credits (kWh/yr)])))" which should return 0.89
Calculation for Goal is:
"Target €/kWh = CALCULATE((Proceeding[Target Cost]*0.35)/Proceeding[Target Credits])" which returns 0.61
Can anyone see the error in this?
HI REIL,
I think this should more related to your data, current it only display the last indicator value. So it will display blank value if last value is blank.
KPI Indicator Showing "(BLANK)"
Regards,
Xiaoxin Sheng
2 Replies
HI REIL,
I think this should more related to your data, current it only display the last indicator value. So it will display blank value if last value is blank.
KPI Indicator Showing "(BLANK)"
Regards,
Xiaoxin Sheng
Ok so this has removed the blank values and will return the last indicator value but it still won't return the total average of the €/kWh which is what I'm after.
