Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Average Measure with filter

Hi,   I want to calculate the average days it take to complete an order with product type 'Computer'. How can I calculate that in a measure? This is a sample of my data: OrderID    OrderDate ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Anonymous 

    you can create a column and measure

    days = DATEDIFF('Table'[OrderDate      ],'Table'[OrderCompleteDate     ],DAY)

Measure = AVERAGEX(FILTER('Table','Table'[Product     ]="Computer"),'Table'[days])

     

    or  you can create a measure directly.

    Measure 2 = 
VAR tbl=ADDCOLUMNS(FILTER('Table','Table'[Product     ]="Computer"),"day2",DATEDIFF('Table'[OrderDate      ],'Table'[OrderCompleteDate     ],DAY))
return AVERAGEX(tbl,[day2])

    pls see the attachment below.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

ryan_mayu Thanks, question: in the second measure, why do you define "day2"?

manikumar34's avatar
manikumar34
Icon for Solution Sage rankSolution Sage
4 years ago

Anonymous ,

 

days2 is defined here as a column for the difference of those tow date columns. You can use othe column name instaed. One first measure dates difference created as a column whereas on 2nd calculation written as a measure, so he is using variable and ADDCOLUMNS functions to define that on measure and use that on AVERAGEX