Average of a measure DAX

[Veree]

Hello everyone,

I'm tring to calculate the average of a MEASURE by using a measure.

If you check the picture I attached, I need the average of the [MEAN1] for the period selected.

373.6667

21.66667

395.3333

= 263.5555556

Anyone can help?

[v-zhangti]

Hi, @Veree 

You can try the following methods.

Measure = Var _table=SUMMARIZE(ALL('Table'),'Table'[Date],"Sum",[MEAN1])
Return
AVERAGEX(_table,[Sum])

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[Veree]

Hi,

Results should be visible into the graph, not in the table. Mean1 is not a column, it is a measure. I need to do the average of a measure and show the result into a graph.

Table looks like this, but measures are outside the table columns.

[Nicola_CMT]

Hey Gurus, 

Anyone able to help ? I have this same issue in my report, that is killing my brain since days.. I have read almost 10 different articles on how to use the AVERAGEX function but none have solved.. Double kudos arriving!

[Veree]

Hi DOLEARY85,

Already did but its not working, it's not giving the expected result.

[DOLEARY85]

Are you able to share the PBIX file?

[DOLEARY85]

Hi,

you could use:

Measure = AVERAGEX('Table Name',[Measure Name])

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍