cancel
Showing results for
Did you mean:

## Difference between Measures from Different Tables

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.

3 REPLIES 3
Community Support

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

Hello @V-pazhen-msft !

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
Community Support

@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

Announcements