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".
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?
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".