Forum Discussion

Mercator_1980's avatar
Mercator_1980
Frequent Visitor
8 years ago
Solved

Calculation of weighted average by multiple groups

Dear all,   an excel has been imported to Power BI Desktop which contains the results of webdata per day.  Some of the values in column "Item" have been labeled falsely and where treated via Power ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Mercator_1980,

     

    You just need to use measure below.

    Measure =
DIVIDE (
    SUMX ( Table1, Table1[count] * Table1[price] ),
    SUMX ( Table1, Table1[count] )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

Mercator_1980,

 

You just need to use measure below.

Measure =
DIVIDE (
    SUMX ( Table1, Table1[count] * Table1[price] ),
    SUMX ( Table1, Table1[count] )
)
syedallam's avatar
syedallam
New Member
6 years ago

Hi,

 

I tried your solution and I am able to get the data over a table value.  Now, what I am trying to do is, us this weighted average to show as line series.  For eg., I have total trades (buy and sell) for multiple currencies (USD, GBP, EUR) and for each month (APR, MAY, JUN).  I have used measure to calculate weighted average rate of these 3 categories. I want to create a Line and clustered column chart with the values shown along with the measure value as a line value.  When I try doing it, it show the average or total of the measure value.

Please help me out.