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 tot...
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 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 I take that back, you were correct! My DAX wasn't. My apologies.