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