Using Slicer for sample size in SAMPLE function

[bdelaure]

Hi all, 

We have a large sales listing out of which we want to take random samples.

We would like to use a slicer which indicates the number of samples to be taken.

The slicer is based on a table including a list from 1 to 10.

Therefore we thought to use the following formulla:

Selection = SAMPLE( SELECTEDVALUE(SampleSize[SampleSize]), SalesFY18, SalesFY18[Invoice amount])

But this function is not working. 

Could one of you maybe help me out?

Many thanks

Brecht

[v-yulgu-msft]

Hi @bdelaure,

SAMPLE() function returns a calculated table that lists a sample of N rows from the specified table. A calculated table is static once it has been initilized, won't be dynamically changed based on slicer selection. So, above requirement cannot be achieved now.

Regards,

Yuliana Gu

[bdelaure]

Is there maybe any other easy solution?

Currently we are working with static tables and use the input of these tables for our sample size number.

Many thanks for your help!