Forum Discussion
How to calculate averages in a Matrix visual using INSCOPE for different groups?
Hi, I am attempting to fill a matrix based on a table shared here. H P V A Tool U I APP1 V1 A1 05 1 I APP1 V1 A1 07 1 I APP1 V1 A1 08 1 I APP1 V1 A1 09 1...
Thanks for your reply Ibendin
See below in Excel what I am looking for:
In PowerBI the Data is being displayed this way but the problem is with the results I am getting in the rows for H and P.
lbendlin
Super User
Super UserPlease provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Hi lbendlin
Below is the table that can be use to represent the outcome I showed before.
H P V A Tool U I APP1 V1 A1 01 100% I APP1 V1 A1 02 100% I APP1 V1 A1 03 80% I APP1 V1 A1 04 50% I APP1 V1 A1 05 30% I APP1 V1 A1 06 80% I APP1 V1 A1 07 50% I APP1 V1 A1 08 80% I APP1 V1 A2 01 60% I APP1 V1 A2 02 80% I APP1 V1 A2 03 50% I APP1 V1 A2 05 30% I APP1 V1 A2 07 50% I APP1 V2 A3 01 50% I APP1 V2 A3 04 40% I APP1 V2 A3 08 20% I APP1 V2 A4 03 80% I APP1 V2 A4 06 100% I APP2 V3 A5 01 10% I APP2 V3 A5 03 20% I APP2 V3 A5 04 30% I APP2 V3 A5 05 50% I APP2 V3 A5 07 30% I APP2 V3 A5 10 50% I APP2 V3 A6 01 60% I APP2 V3 A6 03 50% I APP2 V3 A6 05 30% I APP2 V4 A7 01 50% I APP2 V4 A7 04 40% I APP2 V4 A7 08 20% I APP2 V4 A8 03 80% I APP2 V4 A8 06 100% Thanks for your support