Forum Discussion
Create Sample table based on users Productivity
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...
hi amitchandak
it works fine, but then i want to have random sample table based on that,
can you help me?
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
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.