How to compute percentage of column

[angevin17]

Hello,

I have a column in a table called name and that is accociated with another column called count. I'm trying to make a new column/measure that finds the total count and then divides each count row by that total count.

I made a quick example below:

I have the name and count columns. I want to add the count column and then divide each count row by that total count.

Thank you so much!

[Jihwan_Kim · Accepted solution]

Percentage CC =

DIVIDE(Data[Count], SUM(Data[Count]))

Link to the pbix file 

[ryan_mayu]

@angevin17 

maybe you can try

countrows(table) /  calculate(countrows(table),all(table))