Forum Discussion
Divide each value by total row
I have a matrix in power bi as below
| City | item 1 | item 2 | item 3 | Totals |
| C1 | 30 | 34 | 21 | 85 |
| C2 | 22 | 34 | 21 | 77 |
| C3 | 32 | 33 | 43 | 108 |
the values are distinct counts of IDs and the totals are provided by power bi
now I want the same table but with percentage (each value divided by the Total of the row)
for example C1,item1 = 30/85
so I will get something as below
| City | item 1 | item 2 | item 3 | Total |
| C1 | 35% | 40% | 25% | 100% |
| C2 | 29% | 44% | 27% | 100% |
| C3 | 30% | 31% | 40% | 100% |
3 Replies
you are welcome!