Forum Discussion

RK_UA's avatar
RK_UA
Regular Visitor
4 years ago
Solved

Weighted Average

Good day Power BI community,   I am looking for your expertise in calculating Overall Weighted average for 2nd Item number.   In the last two columns I am using formulas for Weighted Average unde...
Need Help
  • RK_UA's avatar
    RK_UA
    4 years ago

    I have found a solution to this by adding Calculated column in my Data with the following formula

    Can now close this. Thanks for  the help.

     

amitchandak's avatar
amitchandak
Super User
4 years ago

RK_UA ,A measure should be like

 

divide(sumx(Table,[Unit_Cost_USD] *[PDUORG]), Sum(Table[PDUORG]) )

RK_UA's avatar
RK_UA
Regular Visitor
4 years ago

Hi Amit,

 

After using the formula I get the following:

 

 

In the last column for Weighted average, I need to get 518.57 for all three lines. This will be the weighted average for the 2nd Item number 100020 for All Orders (Second column).

 

What is the formula for this?

 

RK