Forum Discussion
ripstaur
Helper III
Helper IIIMatrix row totals are incorrect
I have been trying to show some measure of cross-correlation between a criticality factor and a performance rating. I was hoping to use weighted averages, but the weighted average function in PBI doe...
I think I have it figured out. PBI is averaging the actual values, not the averages of the values for the products. I think that's actually a better way to do it.
Greg_Deckler
Community Champion
Community Championripstaur Go into Power Query Editor. Create a New Blank Query. Click on Advanced Editor. Ctrl-A to select all the code. Copy in all the code that I provided replacing everything that is currently in the blank query. Save the query.
ripstaurHelper III
Helper IIII think I have it figured out. PBI is averaging the actual values, not the averages of the values for the products. I think that's actually a better way to do it.