I want to calculate the cost of all campagins belonging to a category in relation of the signed contracts of a similar category in a different table.
The data model. Categories are markedFor testing purposes should the CPO Paid measure display the corresponding budet
The cost are summarized in a campaign table. Each Campaign has a product it advertises. As a purchase facilitated by a campaign does not garantie that the product is of the same category the category of the product is logged in the purchase('Käufe') table.
Both categories share the categories which are of interest ("Strom" and "Gas").