Get % sample of a table at random

[NumeroENAP]

Hi,

I need to filter my table so it only shows 15% of the lines in my table at random (sample round down). Thanks!

Folder

C1

C2

C3

C4

C5

C6

C7

C8

C9

C10

C11

C12

C13

C14

C15

Ex : 

C3

C6

[AlB]

Hi @NumeroENAP 

Interesting request.  Try creating a new calculated table. It will get closer to 15% as the number of rows grows:

NewTable =
FILTER ( Table1, RAND () <= ( 15 / 100 ) )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[NumeroENAP]

In my case, I would prefer a measure, because I can only access to production data (in consultation only). So, I can't create a table. Also, this table is in relation with other dimension tables (ex : results). 

---

@AlB wrote:

Hi @NumeroENAP 

Interesting request.  Try creating a new calculated table. It will get closer to 15% as the number of rows grows:

NewTable =
FILTER ( Table1, RAND () <= ( 15 / 100 ) )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

---