Forum Discussion
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
- amitchandakSuper User
baneworth , Assume you have measure [Passdown_Total] and you need Avg above month level
AverageX(values('Date'[Month Year]), [Passdown_Total])
- baneworthHelper III
Perfect!
Thank you