Forum Discussion

Asantos2020's avatar
Asantos2020
Advocate II
6 years ago

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 P...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Asantos2020
Advocate II
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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