Forum Discussion

Jeff505's avatar
Jeff505
Frequent Visitor
7 years ago
Solved

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 ...
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Jeff505

    You should modify your measure as below in your scenario.

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

     

    Best Regards

    Maggie

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

By simply using ALLSELECTED instead of ALL ðŸ˜€

Answered my own question. Please disregard the question above.