Calculations between two columns in unrelated tables

[Dane]

I have two columns I have created in a BI report that are in tables that are unrelated. The first table contains the first custom column titled TrackingHistory[_BeginningFootage], and the second table contains a column titled InventoryTransDetail[_TotalGoodFootage]. Ideally, I would like to be able to subtract the good footage from the beginning footage to find a waste factor but have not been able to get an accurate number in creating a measure. Any ideas on how this can be done on these two unrelated tables? 

[Dane]

I have created a measure to calculate was basically taking the sum of the starting footage and subtracting the sum of the ending footage. If I look at the chart for the entire YTD or even a month the numbers dont match (first screenshot). However if I drill into a specific week or day the numbers match. Any idea with what I am doing wrong?

[Dane]

Does anyone have some advice on how to fix this issue? Basically, a measure I have created to calculate the difference between starting and ending footage is calculating incorrectly when I look at the data in aggregate, when I drill into a specific day it is correct.

[Ahmedx]

Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result.

[ichavarria]

Hi @Dane,

Why are they unrelated? Is it that you do not want them to be related? Because if they are unrelated, you will not be able to create a measure using fields from both. 

My suggestion is to first find a way in which you can relate them. Power BI recommends the star schema, in which you have the dim tables around the fact: Understand star schema and the importance for Power BI - Power BI | Microsoft Learn.

Once the tables are realted, you will be able to create measures. 

Best regards, 

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and give Kudos to help the other members find it more quickly