Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    You may add a calculated column as follows.

    Column =
SUMX (
    FILTER ( 'Transaction', 'Transaction'[_link] = Budget[_link] ),
    'Transaction'[_amt]
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Anonymous,

 

You may add a calculated column as follows.

Column =
SUMX (
    FILTER ( 'Transaction', 'Transaction'[_link] = Budget[_link] ),
    'Transaction'[_amt]
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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*