cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
markoss92 Helper II
Helper II

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

Accepted Solutions
OwenAuger Community Champion
Community Champion

Re: First N rows

Hi @markoss92,

 

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

3 REPLIES 3
OwenAuger Community Champion
Community Champion

Re: First N rows

Hi @markoss92,

 

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

tekinbk Helper I
Helper I

Re: First N rows

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!

tekinbk Helper I
Helper I

Re: First N rows

Solved! Thanks for your consideration.

Cheers!

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors