Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Weighted average Measure

Hi guys,   i need to create a weighted average measure for the following scenario:   I have 3 SKU on stock with a stock reach of 10 days each (Col: Stock reach per Qty).    They all have 5 quan...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous ,Try like

     

    divide(sumx(all(Table),Table[Stock Unit]*Table[Stock reach]*Table[Stock reach]) ,sumx(all(Table),Table[Stock Unit]*Table[Stock reach]))

     

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

Anonymous ,Try like

 

divide(sumx(all(Table),Table[Stock Unit]*Table[Stock reach]*Table[Stock reach]) ,sumx(all(Table),Table[Stock Unit]*Table[Stock reach]))