Forum Discussion

orourkebp's avatar
orourkebp
Frequent Visitor
9 years ago
Solved

Selecting Random set of Records from a Dataset

Hello all,    New Power BI user.   Tried some examples found on the web but I cannot seem to apply them to this scenario.   I have a dataset of purchases for various branches around the United ...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    orourkebp,

     

    RAND function return a random value for each row. Please refer the screenshot below.

     

    Regards,

    Charlie Liao

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Hmm, you could do this in DAX if you perhaps have a query by state and then create a calculated table where you grab a number of records less than some index. So, in Alabama create a calculated table of and index <= 100. Kind of hacky. Will try to think of a more elegant solution.