Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Average column value different in Power Bi Dax average function

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  t...
Help appreciated
Help me
ValtteriN's avatar
ValtteriN
Community Champion
4 years ago

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

ValtteriN  i have tired above measure but its not  working 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

    • ValtteriN's avatar
      ValtteriN
      Community Champion
      4 years ago

      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: