Percentage between Count Of Every Name and total count of all names

[Anonymous]

Hello so imagine a table where i have 5 names : james, katie,jane,ari,jack.

total employees are 100 and like 20 james, 10 katie , 30 jane , 5 ari, 35 jack

i want to calculate the ratio of each employee name so like james is 20% cause 20/100 *100 is 20% .... ect

NB: NAMES ARE IN A TABLE SO I HAVE 1 column its name : 

Name:

James

James

James

James

.....

i appreciate the help

[Jos_Woolley · Accepted solution]

Hi,

Use a measure:

Employee Ratio =
DIVIDE(
    COUNTROWS( 'Table' ),
    CALCULATE( COUNTROWS( 'Table' ), ALL( 'Table'[Name] ) )
)

Regards

[Anonymous]

Thank You very much