Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calcualte(sum giving an error

Hello Community, i am trying to create a calculated column and i am getting below error.Can i get suggestion? Thanks   Error Message"The expression contains multiple columns, but only a single col...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous

    Perhaps like this?

     

    delete after use =
CALCULATE (
    SUM ( [RAW Valid Months] ),
    FILTER (
        ALL ( '03- Contracts'[Sales Org] ),
        '03- Contracts'[Sales Org] = "AMERICAS"
    ),
    FILTER (
        '04-Software ',
        '04-Software '[P Identifier] = '04-Software '[RAW Unique]
    )
)

     

AlB's avatar
AlB
Community Champion
7 years ago

Hi Anonymous

Perhaps like this?

 

delete after use =
CALCULATE (
    SUM ( [RAW Valid Months] ),
    FILTER (
        ALL ( '03- Contracts'[Sales Org] ),
        '03- Contracts'[Sales Org] = "AMERICAS"
    ),
    FILTER (
        '04-Software ',
        '04-Software '[P Identifier] = '04-Software '[RAW Unique]
    )
)

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you so much AIB.

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Anonymous

    No worries.

    If you're interested, in this article you can read why your first approach was not working.