Filtered random sample

[AviramWeiss]

Hi all,

My task is rather simple, or so I thought. Can't get to solve it or find a proper solution on the net.

I have a large data table, let's say with this structure:

On a desktop page, I let the user slice this data (let's say by City and Firm slicers), and added a "Sample Size" slicer (for simplicity, with absolute numbers, and not percentage):

I want to show a sample result, of course filtered by City and Firm, and with the Correct sample size (assuming there's enough data...).
I thought this would be the easy and correct solution, but the SelectedValue vars return blank values, and the entire sample ends up empty.

When I replace the SelectedValue vars with specific values, it works well, but of course doesn't do what I want:

How do I make the SelectedValue functions "see" the slicers on the page?

[Anonymous · Accepted solution]

Hi @AviramWeiss ,

I tried to reproduced it.

And based on your description, you were creating a calculated table, right?

However, the SELECTEDVALUE function is unavailable in a calculated table. Calculated tables are similar to calculated columns, but different from measures. Measures return results dynamically, so the SELECTEDVALUE function can be used in measures to dynamically return results based on slicer selection. However, calculated tables and calculated columns are static return results, so this does not apply here.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.