Taking Difference between two columns in a Table Visual (Values from different tables)

[danb]

Good Morning!

I feel a bit foolish having to ask this question however I am stumped. I have a table visual that I am trying to layer out a budget and then the actual amount spent per account # per period. There are two different tables (my actual spent and original budget tables). I have them connected via account numbers a Fiscal Period. 

I have them in a Table visual as such:

I am trying to add a "$ Delta" and "% Delta" for the difference between the Budget Amount and Actual Spend. I have tried various measures however I am doing something wrong. Here is an example of one formula:

The problem is when i add this measure in it blows out the dataset. I can see one row where I see what I am looking for (framed in red) however a whole bunch of extra rows show up as well. 

Thanks in advance! 

Dan

[Icey]

Hi @danb ,

I make a sample. If your data structure is similar to mine，the measure you create is meaningless. Because the value of 'Budget Amount' is the whole 'Fiscal Period' and the value of 'Actual Spent' is the specific value of each 'Account Description'. They are not one-to-one correspondence in the Table visual. Then you can tell me what do you want to do, so that I can help you better.

Best Regards,

Icey Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danb · Accepted solution]

@Icey  - thank you for your response. You are spot on and the issue is being caused by the relationship (or lack thereof). I actually went down the path of merging the two tables together into a new table and solved the issue that way. 

Dan