Forum Discussion

SSS's avatar
SSS
Helper I
8 years ago

Weighted Average

Good Afternoon,   I've been struggling with an issue in my task.   My data looks like:   Date                  Company                  Country              Orders                     Type     ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

 SSS,

(4.5*5 + 3.5*8 + 9.5*2) / (5+8+2) equals to 4.63 but not 3.86. Create a masure using DAX below and check if you get expected result.

Weighted average = CALCULATE(SUMX(Table,Table[Orders]*Table[Rotation Index Value]),ALLEXCEPT(Table,Table[Date],Table[Type]))/CALCULATE(SUM(Table[Orders]),ALLEXCEPT(Table,Table[Date],Table[Type]))




Regards,
Lydia

  • SSS's avatar
    SSS
    Helper I
    8 years ago

    Hi Lydia,

     

    Your solution seems a good one but I have an aggregated problem that I forgot to tell.

    The column "Orders" is not in my current table but in a table (let's called it Table2) that is related to the actual table of the problem by the "Date"  column.

     

    Is it possible to do your solution but using the column from the Table2?

     

    thanks!!!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      SSS,

      You can create a Orders column in the current table to bring relevant values of Table2 using DAX, then apply the above DAX formula.

      If you have questions about how  to create the Orders column, please post sample data of your Table2.

      Regards,
      Lydia