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

v-juanli-msft's avatar
v-juanli-msft
Community Support
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