Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Value | Gross Profit % |
100 | 10 |
20 | 30 |
40 | 20 |
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!!!
Solved! Go to Solution.
@erimaz , if they are columns
divide(sumx(Table,Table[Item Value]* Table[Gross Profit %]), sum(Table[Item Value]))
@erimaz , if they are columns
divide(sumx(Table,Table[Item Value]* Table[Gross Profit %]), sum(Table[Item Value]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |