Create table that take value selected

Thanks for the reply from bhanu_gautam , please allow me to provide another insight:

Hi, Anonymous 

Thanks for letting us know your user experience.  According to your case description, I do understand how frustrated you are now.
 

Based on our current understanding of your needs, as you have measured, it is not possible to create a new computed table based on the values of the original table slicer. There are two main reasons for this:

1.Unable to capture values for dynamic slicers: In a calculated table, you can't directly capture the values of another dynamic slicer.

2.Recursion and cyclic dependency risks: Even if it can be implemented, this approach can easily lead to recursion, which can lead to the problem of circular dependency.
 

So, my alternative is：
 

First, copy the query to the data source directly in PowerQuery, and then modify the table according to your needs:
 

Using the Queries pane - Power Query | Microsoft Learn

Then, the table relationship is established in the desktop, so that the interaction between the two tables is realized:

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.