Forum Discussion

erimaz's avatar
erimaz
Frequent Visitor
5 years ago
Solved

DAX formula for weighted average

Hello,

 

I am looking for the correct forumla to calculate weighted value over hundreds of records.

 

Given just a few records, the weighted Gross profit % average for the following items would be: ((100*0.1)+(20*0.3)+(40*0.2))/(100+20+40)

Item ValueGross Profit %
10010
2030
4020

 

Given hundreds of values, is there a DAX formula that allows to multiply only values on the same row, and therefore achieve the weighted average I am looking for?

 

Many thanks in advance for youir support!!!

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    erimaz , if they are columns

     

    divide(sumx(Table,Table[Item Value]* Table[Gross Profit %]), sum(Table[Item Value]))

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    erimaz , if they are columns

     

    divide(sumx(Table,Table[Item Value]* Table[Gross Profit %]), sum(Table[Item Value]))