Hello
I have not seen any other post related to the doubt I have. I do not know if I have not been able to search well because I did not formulate the question correctly. I will try to explain.
I have a model in which, among other things, there are two tables related to each other:
Table 1 sales goal -> for every seller and product category there is a sales goal (not all sellers have goals for all categories. Some, for example, only have a focus on one category, although they can sell other types of products if the opportunity arises.)
Table 2 sales production -> here we have each registered sale, associated with a product and seller, among other things.
What I need is to see the percentage of fulfillment (in different ways aggregated, not at the seller level) but only for each seller/product that has a goal for that product. That is, if the seller Juan has to sell 100 units of electronics and sells 50 units of electronics and 50 of footwear, that his percentage of compliance is 50% and not 100% and that this is also represented in an aggregate way and those sales of footwear that he has had are not taken into account in the overall percentage of compliance.
For this I had thought that the measure only adds the sales of table 2 that make "match" with table 1, but I do not know which formula to use.
I hope I have explained myself correctly.
Thank you very much in advance 🙂
