Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Help required in calculated column which uses sum()

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!

 

 

 

6 Replies

  • HughLa's avatar
    HughLa
    Icon for Resolver IV rankResolver IV
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        HughLa
        Icon for Resolver IV rankResolver IV
        4 years ago

        Is it possible for you to share your DAX?

  • HughLa's avatar
    HughLa
    Icon for Resolver IV rankResolver IV
    4 years ago

    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?