Forum Discussion
Solved
Adding A Percentage Column To A Matrix
Greetings, I hope you are having a blessed day! I am attempting to add a percentage summary to the end of a matrix in my PowerBI report. My current Matrix looks like this: Group ...
Hi,
If you want to create a column, that is calculated the percentage value of passing based on each row, you could use below code ("Column 4" is the column without any title in your message) :
Pass percent = divide( [P], ([P] + [F] + [Column4] ))
Hi
What is the below column?
Group | What is this column ? | F | P | Total |
A | 0 | 12 | 8 | 20 |
B | 1 | 4 | 5 | 10 |
C | 1 | 2 | 7 | 10 |
D | 7 | 8 | 15 | |
E | 1 | 7 | 2 | 10 |
R | 1 | 13 | 6 | 20 |
Total | 4 | 45 | 36 | 85 |
Do you have screen shot of data?
Greetings,
The column without values is a blank column.
Some sample data is reproduced in the table in this message:A P A P A F B C D F R E A P B P C P D F E F R F R F R F D F A F A F A F B F C P D P R P E F A F B F C F D F E F R F R P R P D P A P A F A P B P C P D F R F E F A F B F C P D P E P R F R F R F D F A F A F A F B P C P D P R P E F A P B P C P D F E F R F R F R F D P A P A P A F B F C F D F R F E F A F B P C P D P E P R F R P R P D P
Warm Regards,
~Travian