Creating a measure to average all the values in this chart

[Yosinator]

Does anyone know how I can average the datapoints in this chart? 

[Mikelytics · Accepted solution]

Hi @Yosinator 

Do you work with other measures and do you use filters?

Pleae try the following:

Average =

CALCULATE(
   AVERAGE(TableValue[ColumnWithValue]),
   ALL(TableXAxis[ColumnOnXAxis)
)

or

Average =

CALCULATE(
AVERAGE(TableValue[ColumnWithValue]),
ALLSELECTED(TableXAxis[ColumnOnXAxis)
)

or if you already work with measures and you want to put the average on top:

Average =

CALCULATE(
   AVERAGEX(
      VALUES(TableXAxis[ColumnonXAxis]),
      CALCULATE(
         [Measure]
      )
   )
ALLSELECTED(TableXAxis[ColumnOnXAxis)
)

WIth a little bit more context (data model, measures used as well as filters used) I would be able to give a more specific answer.

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn