Adding a Table for Yearly Target Values

[Brett007]

PBi Report Target Values

I have 3 Locations China Germany and USA

I have 5 Product Lines Product A, Product B, Product C, Product D, Product E

A, B, C Manufactured in China

A, B, D Manufactured in Germany

C, D, E Manufactured in USA

Target Values are different for each Product Line, and Location combination

Here is the part that I am stuck on.  

The Total Team in each Location has a goal called "Central" (All Product Lines, but it is not an avg or sum of Target Values)

I can filter for all of the results and display the results from a data input table that I created, but I don't know how to show "Central".  How do I associate "Central" as representing all of the Product lines when this option is not in any associated columns.  

TLDR: End Goal - Click on a Chiclet Slicer for Location and a separate Chicklet slicer for Product Line, and receieve the target Value in a "Card" visualization.  The Same filters will filter other tables based on the same attributes, but do not know what to do with "Central".

Thank you.

[amitchandak]

@Brett007 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Brett007]

I added a file at the very top.  Thank you.