Make a table out of all selected lines

[Anonymous]

Hello everyone,

I have slicers in my dashboard and I want to create a table from all the rows that are selected by the Slicers. 

I want to create a new table that dynamically refers to these selected lines. How can you do that?

I tried:

dynamic_table = ALLSELECTED('table')

but that returns the whole table 😕

Best regards

Florian 

[Anonymous]

Hi @Anonymous ,

Did johnt75's answer solve your problem? If yes, please mark his answer as a solution to help the other members find it more quickly, if this doesn't work for you, please consider sharing more details about it. And it would be great if there was a sample file without any sensitive information here.

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[johnt75]

I'm afraid that isn't possible, calculated tables are only calculated once on data refresh they do not take account of any slicers or filters that are applied visually.

You can, however, create table variables within a measure and have the measure operate on those variables. It depends on what your final goal for the calculated table is.