Forum Discussion
Random Select with Selective Criteria DAX
Hi Yucy,
"
However I need to keep the sample size but filter something out from the sample pool. Is it possible?
"
<--- Could you share some sample data and clarify more details about your requirement and expected results?
Regards,
Jimmy Tao
Yes, basically we want to do a contract sample auditing semi-monthly. Usually we will get 5000 contract every 15 days by different sales people. We want to do a ramdom sample audit for those contracts revenue greater than 5k. First, we want to get a ratio of contacts per sales, say sales A signed 2000 contracts of the 5000 total, we want to ramdom audit 10% of his/her 2000 contracts which revenue greater than 5000. Sales B may only signed 200 contracts of the 5000 total, so we only want to audit 20 contracts from his'her 200 total contracts. Make sense?
Thnaks