Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |