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 b...
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]))

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]))