Forum Discussion

ripstaur's avatar
ripstaur
Icon for Helper III rankHelper III
5 years ago
Solved

Matrix 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...
Need Help
  • ripstaur's avatar
    ripstaur
    5 years ago

    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. 

ripstaur's avatar
ripstaur
Icon for Helper III rankHelper III
5 years ago

I'm not sure what all that is, but I guess it's M code? 

 

Is there some link somewhere where we can post files? If so, I will put up the example file and a pbix that I built from it. 

ripstaur's avatar
ripstaur
Icon for Helper III rankHelper III
5 years ago

This is the result:

 

What should I do next?