Forum Discussion
Solved
Showing % in Matrix
i have the below chart created in a matrix
| Staff Time | Manager Time | |
| Manager A | 4 | 6 |
| Manager B | 5 | 5 |
| Manager C | 6 | 4 |
however i would like to add % of staff and % of manager time to it as well(below is what i want to display). how do i do that?
| Staff Time | Manager Time | Staff % | Manager % | |
| Manager A | 4 | 6 | 40% | 60% |
| Manager B | 5 | 5 | 50% | 50% |
| Manager C | 6 | 4 | 60% | 40% |
You can add two new measures and then add them to your matrix.
Staff % = DIVIDE( SUM(MGRs[Staff Time ]), CALCULATE(SUM(MGRs[Staff Time ]) + SUM(MGRs[Manager Time]), ALL(MGRs[Staff Time ])), 0) Mgr % = DIVIDE( SUM(MGRs[Manager Time]), CALCULATE(SUM(MGRs[Staff Time ]) + SUM(MGRs[Manager Time]), ALL(MGRs[Manager Time])), 0)
Select the measure on the right side of the UI. Once the measure is selected, click the 'Modeling' tab to the top. From there, you can specify the field format using that 'Formatting' tab.
7 Replies
You can add two new measures and then add them to your matrix.
Staff % = DIVIDE( SUM(MGRs[Staff Time ]), CALCULATE(SUM(MGRs[Staff Time ]) + SUM(MGRs[Manager Time]), ALL(MGRs[Staff Time ])), 0) Mgr % = DIVIDE( SUM(MGRs[Manager Time]), CALCULATE(SUM(MGRs[Staff Time ]) + SUM(MGRs[Manager Time]), ALL(MGRs[Manager Time])), 0)
its not working, is there a number i can call you at?
Perhaps you should provide more details. What does the raw, underlying data look like, what output are you getting versus what you expect? What all have you tried thus far to reach a solution?
