cancel
Showing results for
Did you mean:
Highlighted
Member

## Average Not Returning Correct Number

I have this table:

So the highlighted number is supposed to be the average of that column. However, if I export the results and highlight the entire column from top to bottom I get a totally different number:

The number in the spreadsheet is what I'm looking for but I don't know how or why PBI is returning this random number that doesn't add up in the first screenshot? It could be because of grouping but I'm really not sure.

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

## Re: Average Not Returning Correct Number

@mrainey

you will need to make a measure with a Averagex.
If you only use the aggregator in your Deal Size column, the average will not work for the total amount.
It would look something like this:

`Measure = Averagex ( Values ​​(table [Producer]), CALCULATE Sum (table [Deal Size]) ) `

5 REPLIES 5
Frequent Visitor

## Re: Average Not Returning Correct Number

@mrainey

You are trying to use averagex ?

Member

## Re: Average Not Returning Correct Number

@EugenioJunior  No, I took a column and right clicked and clicked Average. I see what it's doing, it's taking the sum of the column that I'm averaging and calculating the average based on the # of times a person is in the table:

So it's taking 1,132,185.06/735 to get \$1,540.39. But I don't know how to get it to NOT do that since it's doing it by default. I just want it to average the values on the right hand column without taking into account any other table info so it properly returns the correct value. I don't want it to divide by any counts, just the flat out average of the numbers in the column itself.

Frequent Visitor

## Re: Average Not Returning Correct Number

@mrainey

you will need to make a measure with a Averagex.
If you only use the aggregator in your Deal Size column, the average will not work for the total amount.
It would look something like this:

`Measure = Averagex ( Values ​​(table [Producer]), CALCULATE Sum (table [Deal Size]) ) `

Member