Forum Discussion
First N rows
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!
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
4 Replies
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,
OwenHello 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!What was the solve? was it the solution noted above? Thank you.
