Forum Discussion

aktripathi2506's avatar
aktripathi2506
Icon for Helper IV rankHelper IV
10 years ago
Solved

Average error in total

HI,   Please see below the example. In a table/matrix the total of average value is different from the real average.   This is what it look likes in power BI:           And when we calc...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    You need to do an Average of the averages because the total that you see is Allvalues/All Rows.

     

    TO solve this use:

     

    AverageAB = AVERAGEX(SUMMARIZE('Table';'Table'[week];"TheAverageAB";Sum('Table'[A])/Sum('Table'[B]));[TheAverageAB])

     

     

    You can change with your columns name.

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
10 years ago

You want an average of all averages. In excel you are using for the total  the formula verage(Alltheaverages Range) is correct?

 

The average that you are seeing in the visual is: AllmyValues/NumberofRows so the result is different.

 

You can use this measure to solve this:

 

AverageofAB= AVERAGEX(SUMMARIZE('Table';'Table'[week];"AverageAB";Sum('Table'[ValuesA])/AVERAGE('Table'[B]));[AverageAB])