Forum Discussion
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.
Anonymous
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]) )
Sorry about my English.
6 Replies
Anonymous
You are trying to use averagex ?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.
Anonymous
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]) )
Sorry about my English.