Forum Discussion

danish169's avatar
danish169
Icon for Helper I rankHelper I
4 years ago
Solved

Day Grouping Weighted Average

Hello experts,    Having a problem with the following dataset of orders - the order id's are nested under the day of the month:     I need to work out the average market unit rate by calcu...
  • danish169's avatar
    danish169
    4 years ago

    Many thanks I was getting stuck on the visual / dax itself which was throwing my maths off. I just had to divide the total order value by qty and ey voila. 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

danish169 , Create a meausre like

 

Calculate([#DailyWeightedAvg], allexcept(Table, Table[Date]))

 

or

 

Calculate([#DailyWeightedAvg], filter(allselected(Table), Table[Date] = max(Table[Date])) )