Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Wrong total column

I have the following visual:    These are the values of MEDIA_PRAZO_MEDIO column: 1.581775 6.259016 2.271065 3.943498 1.024467 1.413401 0.437936 1.559115 0.03187 ...
Need Help
Show and Tell
MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi Anonymous,

 

Just simulated your calculation in PBI using you data and your measure and my final resulta was 27.824 (image below) breaking down your formula when you are doing the AVERAGE(DADOS[PRAZO_MED]) you make the average of the value multiplied by the %GT so for row 1 you have = 7 * 22,60% = 1,582 but for the total column you have 27.82 (average of the PRAZO_MED) * 100% = 27.824.

 

 

Regards,

MFelix

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

MFelix, neither 20.73 or  27.82 are corrects, calculate that sum on excel, you will see that the right sum is 21.57. So, what am I doing wrong to calculate my weighted averege?