How to filter when slicer table does not have direct relationship with the to be filtered table

I want to get % of sales(AE) with Pipeline and booking in the pie chart I created new column in the Sales table with the below code   Pie Chart: The above code works but it doesn't work when...