KPI Target Goal issue

[REIL]

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? 

[Anonymous · Accepted solution]

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

[REIL]

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.