Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • EugenioJunior's avatar
    EugenioJunior
    7 years ago

    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's avatar
EugenioJunior
Frequent Visitor
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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.