KPI Target Goal issue

[Jeff505]

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

[Anonymous]

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! 

[Anonymous]

By simply using ALLSELECTED instead of ALL 😀

Answered my own question. Please disregard the question above.

[v-juanli-msft · Accepted solution]

Hi @Jeff505

You should modify your measure as below in your scenario.

Measure = CALCULATE(AVERAGE(Table1[Total Opened]),ALL(Table1))

Best Regards

Maggie

[Jeff505]

Awesome, thanks @v-juanli-msft!