Forum Discussion
Solved
Need 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.
[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]
)