Forum Discussion

Jeff_Ng's avatar
Jeff_Ng
Frequent Visitor
5 years ago
Solved

How to calculate weighted average from a same column

Hi,

 

Hope you can help me with this. Many thanks in advance. 

 

I want to create a measure in Power BI to calculate weighted average diameter from a same column/table as shown in table below. This measure must be able to be filtered by Date and Reach in the line chart.   

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello Jeff_Ng ,

    In power query editor, pivot the Item column using values Units.

     

    Then in report create a measure

    Measure = (SUM(TableName[Pipe Length(km)])*sum(TableName[Diameter(mm)]))/SUM(TableName[Pipe Length(km)])
     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello Jeff_Ng ,

    In power query editor, pivot the Item column using values Units.

     

    Then in report create a measure

    Measure = (SUM(TableName[Pipe Length(km)])*sum(TableName[Diameter(mm)]))/SUM(TableName[Pipe Length(km)])