Forum Discussion
Average Not Returning Correct Number
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.
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.EugenioJunior it returned the same result of what I already had :smileysad:
EugenioJunior I take that back, you were correct! My DAX wasn't. My apologies.
Hello EugenioJunior ,
I have similar (or the same problem) I'm not sure...
But, Why we should use SUM function if we want to calculate the AVERAGE?
I'm understanding that if I use VALUES (table["grouping_value") it in order to have the group of rows as 1 block.
In the example Producer.
Kim Williams 211.67
Jill Salisbury 278.76
In my case I have the following situation:
Site and value
Site1 = 71.1
Site2 = 47.5
Site 3 = 51.4
Average that I want => 71.1+47.5+51.4 = 170 / 3 = 56.67
But the showed total is 53.9.
I try Measure = AVERAGEX (Values/Table[site];Calculate ( AVERAGE(table[value]) But the outcome is not that I want.
Could you help me?
Best regards.