Random selection

[PowerBIBeginer]

Hi All,

I've one column i.e. client manager. Entire raw data is always around 5k rows. On the client manager I want to create randomizer which will pick 2 records of every client namager. Means, out 5k rows, if I calculate unique count of client manager then they come aorund 2000 or 2500. I exactly require double records, i.e. example 2000*2 = 4000 records. But those 4000 records should be 2 records of each client manager. 

I tried this but, it's not giving 2 records for every client manager.

[Anonymous]

Hi @PowerBIBeginer ,

This doesn't seem to be possible, DAX is a column based calculation and there is no way to add row data.

Best regards,
Community Support Team_ Scott Chang

[PowerBIBeginer]

Thanks for your reply. but any other way where I can achieve this. Randomly select records any 2 of per client manager. pls guide, if possible