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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        .