Please see the screen shot given below:
There is data in the system like below
Coating line = 3 Galv Major Product = Auto Galvanized and Target = 1000
Coating line = Z Galv Major Product = Auto Galvanized and Target = 2000
But I am not sure if the modelling or the DAX which I have written to achieve this is Summing up the Target for Major Products irrespective anything else.
This post was made in the board for community feedback, which is probably why you haven't had any responses. Since your question is specifically related to the Power BI tool not the community, I would post it in one of the regular forums: https://community.powerbi.com/t5/Forums/ct-p/Forums Thanks!