Forum Discussion
DivakarKrishnan
Helper II
Helper IINeed help on Average over Measure
Dear, I have couple of DAX written in my model, now i want to calculate average for specific items over this measure. As you know Average DAX is taking only table column and not the measure. Plea...
Hello DivakarKrishnan , Not very clear about the category over which you want to calculate the Average, but you can refer that category in your DAX, somewhat like below DAX.
DAX = AVERAGEX( KEEPFILTERS( VALUES( 'Your_Table'[Category_Field] ) ), CALCULATE( [Sum of Net Delivery] ) )
where, 'Sum of Net Delivery' is your Main measure.
Let me know, if this works.
If I answer your question, please mark my post as solution, this will also help others.
DivakarKrishnanHelper II
Helper IIThanks for your response.
I tried the below code and it's working. Thanks a lot..
AVG of PM = AVERAGEX( VALUES( 'Calendar'[MonthNameShort]) , CALCULATE( [Sum of Net Delivery] ) )
Measures are always wrapped in CALCULATE automatically by the engine. You never have to do it yourself.