topic Get a random line from a table that is filtered by a slicer in DAX Commands and Tips

Get a random line from a table that is filtered by a slicer

PeRoma — Fri, 08 Dec 2023 21:05:40 GMT

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!

Re: Get a random line from a table that is filtered by a slicer

Fowmy — Sat, 09 Dec 2023 07:55:23 GMT

PeRoma

A random line can be picked one you select a colour from the slicer, the issue is the number will be static as long as you refresh your model. I think your expectation is not that.

Re: Get a random line from a table that is filtered by a slicer

PeRoma — Sat, 09 Dec 2023 14:06:55 GMT

Hi Fowmy,

Thank you for your reply but you are right, this is not my intension. I want a DAX command pick a random line and show it in a visual. Sorry for not being correct enough.