Forum Discussion
Solved
Weighted Average at Row Level in Power BI Matrix Visual
Trying to develop a Power BI matrix visual which will show raw data in row level. I was able to show row level data by adding the Ranked column to the rows section of visual. Then in the total sectio...
Hi, milonsarker
You can try the following methods.
Average of Teaching_Stipend = DIVIDE(SUMX('Table',[Teaching_Stipend]*[Teaching_Num]),SUM('Table'[Teaching_Num]))Average of Research_Stipend = DIVIDE(SUMX('Table',[Research_Stipend]*[Research_Num]),SUM('Table'[Research_Num]))Is this the result you expected?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
danextian
Super User
Super UserHi milonsarker
Please post a workable sample data (not an image) representing your use case and your expected result from that. For example, in your screeshot, what values do you expect?
I've added the sample data. Also, original post already has the equation for weighted average stipend.