First N rows

[Anonymous]

Hi,

I have a table with some clients and i want to reduce that table in order to get a random 10% sample of clients. How can I do it? (It must be in DAX)

Thanks!

[Anonymous]

Hello everyone!

I am trying to filter the FIRST N rows of a table dynamically (NOT TOP N, FIRST N ROWS!). For instance; lets say I have a table with 20 records. I would like to reach the first 5 rows without doing any ranking, sorting or any other process, just want to get first 5 rows whatever information are in those rows. I also need a slicer to select the N dynamically, so would be awesome if you could help me out about this.

Cheers!

[Anonymous]

Solved! Thanks for your consideration.

Cheers!

[ARAM]

What was the solve? was it the solution noted above? Thank you. 

[OwenAuger · Accepted solution]

Hi @Anonymous,

You can write something like either of these expressions (assuming your original table is called Clients):

Client Sample =
SAMPLE ( 10, ADDCOLUMNS ( Clients, "rand", RAND () ), [rand] )

Client Sample =
TOPN ( 10, ADDCOLUMNS ( Clients, "rand", RAND () ), [rand] )

Both of these add a column [rand] to the resulting table, which could be removed with SELECTCOLUMNS if needed.

Regards,
Owen