Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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!

1 ACCEPTED SOLUTION
OwenAuger
Super User
Super User

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


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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
Not applicable

Solved! Thanks for your consideration.

Cheers!

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

OwenAuger
Super User
Super User

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


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.