Pull Random Ticket number by date and user

[Creature]

Hey All,

long story short we are doing some QA and need to be able to pull random tickets from my analyst. 
We have a column of Number which is ticket number, Assigned to which is User, and then date is labeled as Closed Date CST.

How would I be able to put this on a dashboard or card for someone to use?

[Anonymous · Accepted solution]

Hi @Creature ,

I create a table as you mentined.

Then I think you can create a new calculated column.

Column = RAND()

Next you can create a measure and a slicer.

Measure = 
VAR SelectedColumn =
    SELECTEDVALUE ( 'Table'[Column] )
RETURN
    CALCULATE ( MAX ( 'Table'[Number] ), 'Table'[Column] = SelectedColumn )

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

-Make the ticket numbers unique

-add a random number column

-grab the first x rows sorted by the random number column.