Power BI Calculations - HELP

[Syndicate_Admin]

Each of the red numbers are assigned to a specific supplier, the blue numbers are the target mix for the different suppliers. I need to subtract these values based on the supplier name. I have a large set of data and they are grouped by month and supplier.

Essentially I need to do:

31%-39%
22%-23%

48%-38%

[Anonymous]

Hi @tholland

If you have a one-to-one relationship between the two tables you can just subtract them. If it is a one-to-many or many-to-many relationship then it is more difficult, please provide some sample data so that I can test it.

Best Regards,
Dino Tao

[Syndicate_Admin]

It is not that I need to subtract every value though. I need to subtract certain suppliers (red) from their target mix (blue).