Create Sample table based on users Productivity

[Anonymous]

Hi Expert 

i had question that i want to get random table before, but the answer doesn,t work in my project

what i want to ask is 
from source data like this : 

 hope can generate the Productivity by "username Ori" which mean = count by username

and from that productivity i want to get the 3% (productivity * 0.03) like this : 

and then I want to have Random sample table based on 3% measurement from

productivity each user like below. 

please help, the data is attached

>>> DataSource <<<

[amitchandak]

@Anonymous ,Is

countrows(Table)*.03

not working as a measure ?

[Anonymous]

hi @amitchandak 

it works fine, but then i want to have random sample table based on that, 
can you help me?

[amitchandak]

I would do like

divide(roundup(rand()*10,0),3) 

and would have using 0 as a sample

Also, refer

https://community.powerbi.com/t5/Desktop/DAX-random-sample/m-p/386571

https://chandoo.org/wp/power-query-random-sample/

[Anonymous]

@amitchandak 

I tried all those things but still not as expected,

the random table must be dynamic based on 3% of users productivity, 
if user "sabillat" have 1, then in random table have 1 row, 
if she have 2, then the table have 2 rows.