Forum Discussion

DivakarKrishnan's avatar
DivakarKrishnan
Icon for Helper II rankHelper II
6 years ago
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...
  • bhagyashripatil's avatar
    bhagyashripatil
    6 years ago

    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.

bhagyashripatil's avatar
bhagyashripatil
Icon for Advocate I rankAdvocate I
6 years ago

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.

  • DivakarKrishnan's avatar
    DivakarKrishnan
    Icon for Helper II rankHelper II
    6 years ago

    Thanks 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] ) )
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Measures are always wrapped in CALCULATE automatically by the engine. You never have to do it yourself.