Get a random line from a table that is filtered by a slicer
Hi, I want to get a random line out a table. The table should be filtered by a slicer before selecting the line. Example: the starting table is: ID-no name colour 103 shirts red 204 shirts blue 101 socks red 348 jacket blue 421 jacket green 333 jacket red There is a slicer filtering the colours. I want to use this slicer (at run time) and generate a random selection of e.g. a "red" article. I have had the idea to create a table with all the filtered entries. But I failed to apply the slicer argument to CALCULTETABLE. And the next step should be to get a random line (or ID-no) out of the created table. But may be there is a better way the create the (random) line or ID-no in a different way. Thank you for any help!