Average column value different in Power Bi Dax average function

[Anonymous]

My table looks like below in Excel sheet .  used below Excel function to  find the average value  

=AVERAGE(A1:A12)

But same data set i have loaded into power bi . i have tired  to average value using the below measure

2020 Avg = CALCULATE(AVERAGE('Current Forecast'[Actuals]))

But  power bi average totally different 

How to get same  value in power bi . any idea  .thanks in advance 

[smpa01]

@Anonymous  it is simply not possible, POWER BI will give you exact same result as excel, unless there is something else you have not talked about.

[ValtteriN]

Hi,

Assuming you want to have the average from all of your data, you can just include ALL in your calculate.
E.g. 2020 Avg = CALCULATE(AVERAGE('Current Forecast'[Actuals]), ALL('Current Forecast'))


If you want to have some filter conditions you could use AVERAGEX or something like this:
2020 Avg = CALCULATE(AVERAGE('Current Forecast'[Actuals]), ALL('Current Forecast'),'Current Forecast'[Year]=2020)

I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!

[Anonymous]

@ValtteriN  i have tired above measure but its not  working 

[Anonymous]

@ValtteriN  i want only total sum value average .  but  my measure its convert all cell value to average . 

[ValtteriN]

Hi,

I am not sure if I understood the issue, but based on you messages I assume you want to first summarize your data based on some dimension and then take averages out of these values?

In that case try something like this:

Start data:

Dax:

Summarized average = var vartable = SUMMARIZE(AverageExample,AverageExample[Category],"Value",SUM(AverageExample[Values])) return

AVERAGEX(vartable,[Value])

End result: