Forum Discussion
Adding values to a sum between tables
That looks like something I would have written. Glad it is working.
The only thing I would tend to do differently is use variables when I have measures with multiple calculations in them. It allows me to easily test the components of a measure to find which parts work and which parts are "broken".
Super UserWith that relationship set up as long as you are not using the ID column from Archive Labor as the visual filter you should be able to get your measures to calculate across tables, but I would have to see the measures being used to understand why they are not working for you.
Would a measure be the best way to calculate this? I'd like to display the final value on a card.
When I try to create the measure, the tblReimbursement columns don't "auto-fill" while typing which is what's leading me to believe theres an issue. Is that inherently indicative of a data issue or might I just have to manually type in all the 'Table'[Column] syntax?
- jgeddes
A measure would be the best option for your need here.
I have had some issues with "auto-fill" lately personally. I would type the 'table'[column] and see what the result is rather than assuming auto fill is working.
If you need a hand writing the measure, let me know which table/columns you are wanting to use and I can assist.
Thanks for the tip! I was able to write the measure below and it seems to give the desired output and works when I filter for different project IDs. Would you have done it a different way?
