Difference between Measures from Different Tables

[Asantos2020]

Hello,

The challenge here consists of finding the difference between the measures below:

Overview Table

Product	Cost	Plant
Item1	1.00	Plant A
Item1	2.00	Plant B
Item2	2.50	Plant A
Item2	2.30	Plant B

To find the cost per product, per plant:

Cost Plant A = CALCULATE(SUM('OverviewTable'[Cust]);'Overview'[Plant]="Plant A")

Cost Plant B = CALCULATE(SUM('OverviewTable'[Cust]);'Overview'[Plant]="Plant B")

Cost Table

Product	Cost
Item1	1.10
Item2	1.90
Item3	2.30

Cost ERP = SUM(Cost Table[Cost])

I now need to find the difference between costs for a product and plot it on a line chart.

The relationship is as follows:

Product Table filters Overview Table

Product Table filters Cost Table

I've tried just subtracting one by another, but it gives me like 795 on a certain month, even though I got the visual filtered on a specific product.

The cost / product / plant and the Production Cost are plotted correctly, but not the difference measure I'm trying to come up with.

Thanks for your help!

[Anonymous]

Hi, @Asantos2020 

And you want have the difference between costs for a product, what about the Plant A or B.

Could provide the pbix if possible, so I can create something similar to yours and help your out. 

Best,
Paul

[Asantos2020]

Hello @Anonymous !

I would then need to find the differences between:

Cost ERP = SUM(Cost Table[Cost])

and 

Cost Plant A = CALCULATE(SUM('OverviewTable'[Cust]);'Overview'[Plant]="Plant A")

and also between:

Cost ERP = SUM(Cost Table[Cost])

and 

Cost Plant B = CALCULATE(SUM('OverviewTable'[Cust]);'Overview'[Plant]="Plant B")

...and have these differences plotted as tooltip.

Not sure if this is too much to ask without the file. If so, I'll have to create the datasets, as the one I'm working on contains confidential data.

Thanks. Cheers!

Antonio

[Anonymous]

@Asantos2020 

I find no problem with the difference with the sample I created based on your original post.

Please create a sample pbix that similar to your dataset, including the related columns and relationship between tables,

Paul