Forum Discussion

buttercream's avatar
buttercream
Helper II
3 months ago
Solved

DAX to flag sample based on ID

Hi,   How do I flag 3 Sales Ids randomly from a table that looks like this: Sales ID Date Item Price 111 3/29/2026 390 27 111 3/29/2026 613 33 111 3/29/2026 211 41 1...
  • oussamahaimoud's avatar
    oussamahaimoud
    3 months ago

    Really !? 🤔

     

    Now, try this :

     

    Sample Flag =

    VAR CurrentID = 'Sales'[Sales ID]

     

    VAR AllSalesIDs =

        DISTINCT( 'Sales'[Sales ID] )

     

    VAR RankedIDs =

        ADDCOLUMNS(

            AllSalesIDs,

            "@Rand", MOD( 'Sales'[Sales ID] * 1140671485 + 128201163, 134456 )

        )

     

    VAR Top3IDs =

        TOPN( 3, RankedIDs, [@Rand], ASC )

     

    VAR IsSelected =

        COUNTROWS(

            FILTER( Top3IDs, 'Sales'[Sales ID] = CurrentID )

        ) > 0

     

    RETURN

        IF( IsSelected, "Sample", "" )

     

    Hope this helps! Don't forget to mark as solution and 👍 in order to keep helping others 🙂