Forum Discussion
SUMX - How do sum information from one table into another
I would like sum in a lookupvalue. Is that possible or is there another command(s) that I need to look at to achieve my desired outcome? I have a budget table with a field and would like to scan a t...
Anonymous,
You may add a calculated column as follows.
Column = SUMX ( FILTER ( 'Transaction', 'Transaction'[_link] = Budget[_link] ), 'Transaction'[_amt] )
Anonymous,
You may add a calculated column as follows.
Column =
SUMX (
FILTER ( 'Transaction', 'Transaction'[_link] = Budget[_link] ),
'Transaction'[_amt]
)
Thank you for your answer, Sam. I get the following message when I put in the code:
A single value for column 'Budget Order' in table '_2018_Budget' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Any thoughts?
Respectfully,
Jonathan M*
Your code works like a champ, Sam. Thank you for your time and effort. It is greatly appreciated.
Respectfully,
Jonathan M*