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 advice.

 

I have a table containing closed support tickets. I have added a table visual to a page and it has been filtered on tickets closed the previous week using a slicer. From this data, 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.

 

How might I go about this?

 

My table includes columns such as reference number, status, customer, raised user, start date, end date, title, support group, assignee

Need Help

2 Replies

  • 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