Forum Discussion

Anonymous

Not applicable

6 years ago

random sampling

[ Spoiler ] How to take number of rows as input and show random set of rows ?

Anonymous

Not applicable

6 years ago

check it out here

https://community.powerbi.com/t5/Desktop/DAX-random-sample/td-p/386571

Random Selection =

VAR SampleSize = 10

VAR TableWithRand = ADDCOLUMNS ( OriginalTable, "Rand", RAND () )

RETURN TOPN ( SampleSize, TableWithRand, [Rand] )

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

Anonymous
Not applicable
6 years ago
how to take row count from users?
- Anonymous
  Not applicable
  6 years ago
  Create one table generateseries(1,1000)
  
  then add it in slicer
  
  Allow user to select number of samples
  
  and undate it in above formula .
  in var section add selectedvalue(table[series]) instead of 10.
  
  Thanks & regards,
  Pravin Wattamwar
  www.linkedin.com/in/pravin-p-wattamwar
  
  If I resolve your problem Mark it as a solution and give kudos.
  - Anonymous
    Not applicable
    6 years ago
    thanks for the reply , but not working unfortunately.