Forum Discussion
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. Please guide me on how to take average over this below measure.
Main Measure : Need average over this Sum of Net Delivery Measure.
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.
4 Replies
[Avg Over Items] = averagex( values( ItemsDimension[ItemId] ), // Please note that if // [your measure] = BLANK() for // some ItemId, then this value // will NOT be taken into account. // If you want to treat BLANK() as // 0 and do include it in the calculation // you have to add 0 to the measure: // [your measure] + 0 [your measure] )- bhagyashripatil
Advocate I
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.
DivakarKrishnanThanks 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] ) )
