Forum Discussion
Calculate the difference between the value in one table and the sum of values in another table
My bad. I didn't properly understand your reply at first but after watching a video on DAX Functions I saw that I was not selecting "New Measure" to create the calculation. It works now. Thank you so much for your help.
Getting closer.
But I need to match the single Revenue value (by Project) within the Revenue table to the SUM of the Costs (by Project) in the Cost table.
So how do I identify the single project? In the equation you provided the value of the Profit MEASURE never changes, regardless of the Projects I select.
In the screen shot below, the answer to ARK-AUI should be $5,356. There is a single vaalue for revenue and multiple values for cost.
My bad. I didn't properly understand your reply at first but after watching a video on DAX Functions I saw that I was not selecting "New Measure" to create the calculation. It works now. Thank you so much for your help.