Forum Discussion
KPI Target Goal issue
Hey all, new to powerBI and having a little trouble with the KPI visulization.
Issue: when using an average measure for some data, the Target Goal in the KPI does not use the average number. It appears to just take the current data number.
Example:
KPI Indicator feild value: 207
Value from my Average measure: 177.78
Using my Average measure for the Target Goal in the KPI produces "Goal: 207.00"
Here's a sample of the data used for the average measure (Average = average(Weekly History[Total Opened])
Week Total Opened
| 2018-08-19 | 116.00 |
| 2018-08-26 | 127.00 |
| 2018-09-02 | 162.00 |
| 2018-09-09 | 184.00 |
| 2018-09-16 | 204.00 |
| 2018-09-23 | 218.00 |
| 2018-09-30 | 177.00 |
| 2018-10-07 | 205.00 |
| 2018-10-14 | 207.00 |
Any ideas would be greatly appreciated!
Cheers, Jeff
Hi Jeff505
You should modify your measure as below in your scenario.
Measure = CALCULATE(AVERAGE(Table1[Total Opened]),ALL(Table1))
Best Regards
Maggie
4 Replies
Hi Jeff505
You should modify your measure as below in your scenario.
Measure = CALCULATE(AVERAGE(Table1[Total Opened]),ALL(Table1))
Best Regards
Maggie
Awesome, thanks v-juanli-msft!
Hi v-juanli-msft , I have a similar requirment and came across this solution, thank you!
Understand that "ALL" removes all filters, but any thoughts how to make this measure work with a date slicer?
Let's say I need to select september dates only, in this case average will be (162+184+204+218+177)/5=189, and the KPI visual will display red - 177 (last value in september), goal 189 (average for september)
So in other words ALL will remove filters for the KPI visual calculations, and yet apply date filter as specified by the date slicer.
Tried with ALLEXCEPT, but it won't help as we are still workign with the same Date column for which filter is not needed (KPI visual) and needed (date slicer)
Thank you!
