Divide each value by total row

[Anonymous]

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%

[Anonymous]

Working as expected thank you!

[VahidDM]

you are welcome!

[VahidDM · Accepted solution]

Hi @Anonymous 

Please use the measures same as attached file:
result in file:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn|Twitter|Blog |YouTube