Help required in calculated column which uses sum()

[Anonymous]

Hello All. Below  I am attaching a picture where there's a column in my table called as "Opportunity value" and every "account manager" column can have 'n' number of "opportunities" and "opportunity value". So I need to create a calculated column in which i have to show the "Sum of the "opportunity value" mapped to the particular "account manager"" . That calculated column will be the total revenue of the account manager. Please help me with the calculated column formula. Any help would be much appreciated. Thanks in Advance!

[HughLa]

I managed to get this result.

You can create a calculated table with Summarize() and return a GroupBy()

i.e.

Then create a relationship between your tables

I hope this is what you are trying to achieve.

[Anonymous]

@HughLa when i tried that i am getting this error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

[HughLa]

Is it possible for you to share your DAX?

[Anonymous]

.

[HughLa]

@Anonymous 

Is your table name table? If so, please escape it with single quotes ''.

Try this:

revenue measure = var a = SUMMARIZE('table','table'[Account_Owner_Name],"total",SUM('table'[Opportunity_value]))

return

GROUPBY(a,'table'[Account_Owner_Name],[total])

[HughLa]

Hi @Anonymous 

How would you want to visualize this new column? Can you not create a measure that sums that column? Or you can enable row totals on your table?