Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Random sample to select 2 rows per person

Hi everyone,   I've been Googling and reading to try and find a solution however struggling to piece examples I have found together to match my scenario. I'm hoping you brilliant people can offer a...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

I want to select individuals/ticket assignees (can be done via a slicer or any other suggestions) who closed a ticket last week and have Power BI present a random ticket. I need the ability to select the individual and multiple ones, not all individuals would get selected.

 

I still have a little confused about your scenario.

 

If it is convenient, could you share your data sample and your desired output so that I could understand your scenario better.

 

In addition, what do you mean of "have Power BI present a random ticket"?

 

Best Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-piga-msft 

     

    You can download sample data that resembles the type of information I'm working with here https://1drv.ms/f/s!AvDRYI7zzwDhoE0qyYcG3GHxtX7x

     

    In my sample data, I have 10 Assignees and each of them has closed/resolved 10 tickets each last week. 

     

    I want the table visualisation on the Power BI dashboard to select at random one ticket for each of the selected Assignees in the slicer. In the saved Power BI file, I have selected two Assignees, I only want the table to show me one random ticket for each.

     

    If there's a better way to do this other than a table, I'm happy for other suggestions too.

     

    The idea is to have a random ticket selection to then conduct an internal audit/review.

     

    Any help would be enormously appreciated as I'm not sure how I can go about this.

     

    Thanks,

    Amy