Forum Discussion
Select sample values from a table dynamically based on Slicer
Hi , I am new to the forum , so thank you all in advance. I am trying to create virtual table, by randomly selecting 1 or more rows from a table depending on the single value selection that is d...
Hi EnnisT,
If I understand your requirements correctly, I'm afraid we can't do it like that. Because the table (the calculated table ) can't respond to the slicer.
What's the expected result? Maybe we can do it with measures. Can you share a dummy sample?
Best Regards,
Dale
Thanks Dale,
The sample data is as follows. There are stores distributed into two regions and each store has a cost value.
In the model , as a part of restructring 'some' of the stores will be closed and cost savings will be calculated.
The quantity of the stores to be closed needs to be selected with the slicer. But the stores should be selected randomly , any of them may be closed.
Ennis