Forum Discussion
Weighted Sum
Hi neskowin ,
The information you provided is rather vague, perhaps you could provide me with the pbix file?
Please be careful not to log into your account in Power BI Dektop and not to include sensitive information when uploading the pbix file.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Thank you for the prompt response. I am not able to attach my PBIX file as it is huge. Instead, I constructed an Excel sheet with sample data that illustrate my PBIX file and the desired outcome. I hope the problem description is clear. I am not able to attach the .xlsx file to this message. Hence, I have tried to copy its content below. Thank you.
Matrix Visual (the Value columns are measures). The measures are to be referenced in the Weight Sum.
Parts Sytem X vs. System Y System X vs. System Z System Z vs. System XX Weighted Sum PartA 0.976 0.925 1.031 ? PartB 0.968 0.900 1.042 ? PartC 0.971 0.910 1.037 ? PartD 0.963 0.886 1.048 ? PartE 0.963 0.888 1.047 ? Weights Table
Measure Name Weight Sytem X vs. System Y 5.2 System X vs. System Z -7.1 System Z vs. System XX 8.9 The "Weighted Sum" in the Matrix Visual should be as follows:
(Sytem X vs. System Y * 5.2 + System X vs. System Z * -7.1 + System Z vs. System XX * 8.9) / SUM of all weights)
The numbers used as multipliers are from the corresponding rows in the Weights Table.Results Table
Systems Parts Attribute1 System X PartA 123.1 System X PartB 89.7 System X PartC 101.3 System X PartD 77.5 System X PartE 79.1 System Y PartA 126.1 System Y PartB 92.7 System Y PartC 104.3 System Y PartD 80.5 System Y PartE 82.1 System XX PartA 129.1 System XX PartB 95.7 System XX PartC 107.3 System XX PartD 83.5 System XX PartE 85.1 System Z PartA 133.1 System Z PartB 99.7 System Z PartC 111.3 System Z PartD 87.5 System Z PartE 89.1
