Forum Discussion

baneworth's avatar
baneworth
Helper III
5 years ago
Solved

Calculate Average from Measure

Dear All,

 

please forgive me, i saw calculation for average of measure has quite some threads but i couldnt understand the solution

provided to the topics there.

 

So please let me share my condition.

 

I created Measures to collect Cycle Time for a product broken down (Assembly, Test, Prep,...)

Then i have one Measure to summarize them all for the total (Passdown_Total).

 

 

Now i need the DAX for average of the total (Passdown_Total)  for monthly average table.

 

Thank you

BR

Matthias

  • baneworth , Assume you have measure [Passdown_Total] and you need Avg above month level

     

    AverageX(values('Date'[Month Year]), [Passdown_Total])

2 Replies

  • baneworth , Assume you have measure [Passdown_Total] and you need Avg above month level

     

    AverageX(values('Date'[Month Year]), [Passdown_Total])