Retrieve all record of a filtered table (visual) in another table (visual)

[Bernard_yu]

Hello,

I'm working with dataset with a main table of 2 millions of rows and couple dimensions
Let's consider that these 2 millions rows are in fact 250k articles but in different states/date/... . Around 8 variations per articles thus 2 millions rows in total. Most variations are in the main table, some others are in dimensions.

I have a view where I filter by year with a slicer, for example for 2022, I obtain 2000 rows and maybe around 250 disctinct articles.

Now, I need a table with all records (all states/dates) of these 250 articles. I can't manage to retrieve the list of articles obtained after applying all my slicers.
In my example I slice by date, but I can slice on others variables too.

Any way to obtain this ?

Thanks for your help.

[Bernard_yu]

Anyone has any idea on this topic ?

Since I import my data, I can easily create/modify tables.

Thanks for your help