Forum Discussion

yaudje's avatar
yaudje
Frequent Visitor
3 years ago

Aggregated Column

Hi Folks,

 

Hope someone can help me on this one. Im working on a table but its a bit challenging to do the calculation of a new column which is an aggregate of 2 elements. I have attached a screenshot of the original table sample and the desired output column with remarks. 

 

Thank you in advance for those who will answer. 

 

Cheers!

 

General Comment
Tips and Tricks

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    3 years ago

    yaudje 

    pls try this

    Column = CALCULATE(sum('Table'[Year1]),ALLEXCEPT('Table','Table'[Sales Rep],'Table'[Customer]))