Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Subtracting Columns from Two Related Tables - Values Multipling

I have a scenario where I want to subtract a fixed monthly target from a dollar figure, each month, for a series of contracts.  I have a related table that defines the contract number and the fixed target I want to use each month.  When I create a table showing the contracts, useage dollars, month and target from related table, everything looks as it should. 


The problem begins when I add in the column as a RELATED column.  I did this so I can make a quick calculated column to show am I above or below target.  What I am seeing is some inconsistent behavior where the related value added is multiplied 10X or up to 12X the original number.


 PBItable image2.png 


 My question is simple, why is the behavior happening and what is the best way to subtract two columns from seperate, but related columns?  Adding in Related, then doing quick Calculated Column OR calculated Measure. 


Any and all advice is appreciated.  




Helpful resources

T-Shirt Design Challenge 2023

Power BI T-Shirt Design Challenge 2023

Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!